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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
