[SQL] Returning a set from an function

2006-04-08 Thread Keith Hutchison
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)---

Re: [SQL] Returning a set from an function

2006-04-08 Thread Tom Lane
"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