Can PL/PGSQL function return multiple SETOFs

From: <cyw(at)dls(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Can PL/PGSQL function return multiple SETOFs
Date: 2008-10-20 22:06:41
Message-ID: 50BF226E06604FF7A100BAA61325AF5D@nc05072019
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is something like this possible?
CREATE testsetof( IN toad_id integer) RETURNS SETOF road_table, SETOF int4
AS $BODY$....

If yes, is this the way to do 'RETURN NEXT'?
RETURN NEXT road_table_row, an_integer;

Thanks
CYW

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-10-20 22:45:31 Re: [HACKERS] Hot Standby utility and administrator functions
Previous Message Greg Smith 2008-10-20 21:51:41 Re: [HACKERS] Debian no longer dumps cores?