Record type in sql - Mailing list pgsql-sql

From Din Adrian
Subject Record type in sql
Date
Msg-id opskqyeodpawcxfg@adi
Whole thread Raw
List 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/


pgsql-sql by date:

Previous
From: KÖPFERL Robert
Date:
Subject: Re: TEXT type blob extraction in ecpg
Next
From: KÖPFERL Robert
Date:
Subject: Re: Record type in sql