Joshua D. Drake wrote:
> Hello,
>
> O.k. I know I can do:
>
> CREATE FUNCTION foo() RETURNS SET OF text AS ' ' language SQL;
>
> Does anyone else think it would be nice to be able to do:
>
> CREATE FUNCTION foo() RETURNS SET OF text,int4,float,timestamp AS ' '
> language SQL;
>
> ?
>
> We could even extend it farther:
>
> CREATE FUNCTION foo() RETURNS SET OF text AS first_name, int4 AS id
> etc....
>
>
You mean like this?
create type bar (firstname text, id int);
create function foo() returns setof bar as ' ' language sql;
cheers
andrew