Yo can do s.t. similar, if the order in which you select the columns corresponds to the order your type is defined. So you'd gonna use: select intcol, textcol from table;
> -----Original Message----- > From: Din Adrian [mailto:[EMAIL PROTECTED] > Sent: Montag, 17. Jänner 2005 13:31 > To: pgsql-sql@postgresql.org > Subject: [SQL] Record type in sql > > > Hello, > I have a little problem > I want to declare a type record for later use like that > > create type record_structure1 as (id int2, nume text); > that is ok! > > next in a function I want to use something like that: > > select * from table as record_structure1 ? > instead of writing > select * from table as t1(id int2, nume text); > is this possible? > > Thank You, > Adrian Din > > -- > Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index > scan if your > joining column's datatypes do not match > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org