Re: returning dynamic record - Mailing list pgsql-general

nick <nick@walkerdatanet.com> writes:
> Just wondering, if it is possible to do the following
> create function foo() RETURNS Record(int, varchar, int)

OUT parameters (in reasonably recent PG releases).

regression=# create function foo (f1 out int, f2 out varchar, f3 out int) as
$$ select 42, 'foo'::varchar, 43 $$ language sql;
CREATE FUNCTION
regression=# select * from foo();
 f1 | f2  | f3
----+-----+----
 42 | foo | 43
(1 row)

            regards, tom lane