Re: [GENERAL] Can PL/PGSQL function return multiple SETOFs

2008-10-20 Thread Pavel Stehule
Hello plpgsql should return only one set. You should to returns set of cursors - that is real multisets. http://www.postgresql.org/docs/8.3/interactive/plpgsql-cursors.html regards Pavel Stehule 2008/10/21 <[EMAIL PROTECTED]>: > Is something like this possible? > CREATE testsetof( IN toad_id in

[GENERAL] Can PL/PGSQL function return multiple SETOFs

2008-10-20 Thread cyw
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o