Re: [SQL] Returning a set from an function

Keith: This is the general approach I use over and over and over -- This is a PLPGSQL function that returns a SETOF tablename%ROWTYPE If you need the full schema and table and everything that goes with this -- let me know --- CREATE OR REPLACE FUNCTION sys_aclsubmenu(int4) RETURNS SETOF sys

Re: [SQL] Returning a set from an function

"Keith Hutchison" <[EMAIL PROTECTED]> writes: > Looking for an example showing how to return a set from either a sql > function or a plpsqq function. Try "SQL Functions Returning Sets" here: http://www.postgresql.org/docs/8.1/static/xfunc-sql.html In plpgsql you just "RETURN NEXT" each value (typ

[SQL] Returning a set from an function

G'day, Looking for an example showing how to return a set from either a sql function or a plpsqq function. Thanks -- Keith Hutchison http://balance-infosystems.com http://realopen.org http://www.kasamba.com/Keith-Hutchison ---(end of broadcast)---