insert new type (object ?) - Mailing list pgsql-hackers

From Loïc TREGOUËT
Subject insert new type (object ?)
Date
Msg-id 390ECAB7.F343B0C4@cri74.org
Whole thread Raw
Responses Re: insert new type (object ?)  (JanWieck@t-online.de (Jan Wieck))
List pgsql-hackers
    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



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Request for 7.0 JDBC status
Next
From: Bruce Momjian
Date:
Subject: Re: Request for 7.0 JDBC status