Record type in sql

From: Din Adrian <adrian(dot)din(at)easynet(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: Record type in sql
Date: 2005-01-17 12:31:26
Message-ID: opskqyeodpawcxfg@adi
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-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/

Browse pgsql-sql by date

  From Date Subject
Next Message KÖPFERL Robert 2005-01-17 12:48:49 Re: Record type in sql
Previous Message KÖPFERL Robert 2005-01-17 07:33:28 Re: TEXT type blob extraction in ecpg