insert new type (object ?)

Поиск
Список
Период
Сортировка
От Loïc TREGOUËT
Тема insert new type (object ?)
Дата
Msg-id 390ECAB7.F343B0C4@cri74.org
обсуждение исходный текст
Ответы Re: insert new type (object ?)  (JanWieck@t-online.de (Jan Wieck))
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Request for 7.0 JDBC status
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Request for 7.0 JDBC status