Re: SetOf Functions

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