Thread

1. insert new type (object ?)

   Loïc TREGOUËT <loic@cri74.org> — 2000-05-02T12:31:51Z

       I've ever ask my question (differently) in the other lists but no
   response , so i think you are my last chance ....
   
   I have the following table in my PostgreSQL Database :
   
   create table one ( i int4 , j int4) ;
   
   create table two ( o one , id int4 ) ;
   
   insert into one values  (10, 20) ;
   
   create function fct() returns one as '
   select i as i , j as j from one ; '
   language 'sql';
   
   insert into two (select fct() , 1 ) ;
   
   So when i do : select * from two
   
               o                                i d
   136801144                        1
   
   --------------------------------------------------
   What is the first number ? I 've succeed with insert a new type ( one)
   into my base ?
   But i can't access to the information into o ?
   
   Please , if you have any information about this problem , please contact
   me
   
               loic@cri74.org
   
   
   thanks
   
   
   loic
   
   
   

2. Re: insert new type (object ?)

   Jan Wieck <janwieck@t-online.de> — 2000-05-02T14:11:45Z

   Looc TREGOUKT wrote:
   >     I've ever ask my question (differently) in the other lists but no
   > response , so i think you are my last chance ....
   >
   > I have the following table in my PostgreSQL Database :
   >
   > create table one ( i int4 , j int4) ;
   >
   > create table two ( o one , id int4 ) ;
   >
   > insert into one values  (10, 20) ;
   >
   > create function fct() returns one as '
   > select i as i , j as j from one ; '
   > language 'sql';
   >
   > insert into two (select fct() , 1 ) ;
   >
   > So when i do : select * from two
   >
   >             o                                i d
   > 136801144                        1
   >
   > --------------------------------------------------
   > What is the first number ? I 've succeed with insert a new type ( one)
   > into my base ?
   > But i can't access to the information into o ?
   >
   > Please , if you have any information about this problem , please contact
   > me
   
       IIRC  it  should  be the in memory address of the tuple table
       slot returnd by the function fct() at  the  INSERT  time.  At
       least, nothing useful.
   
       This  is  definitely  broken and for now you should stay away
       from functions returning tuples or SETs.
   
   
   Jan
   
   --
   
   #======================================================================#
   # It's easier to get forgiveness for being wrong than for being right. #
   # Let's break this rule - forgive me.                                  #
   #================================================== JanWieck@Yahoo.com #