Re: [SQL] Need help with plpgsql function.

On Saturday 13 November 2010 11:15:51 pm Pavel Stehule wrote: } Hello you can use a RETURN QUERY statement - some like CREATE OR REPLACE FUNCTION foo(IN i int, OUT a int, OUT b int) RETURNS SETOF RECORD AS $$ BEGIN IF i = 1 THEN RETURN QUERY SELECT 10,20 UNION ALL SELECT 30,40;

Re: [SQL] Need help with plpgsql function.

2010/11/14 Adrian Klaver adrian.kla...@gmail.com: On Saturday 13 November 2010 11:15:51 pm Pavel Stehule wrote: } Hello you can use a RETURN QUERY statement - some like CREATE OR REPLACE FUNCTION foo(IN i int, OUT a int, OUT b int) RETURNS SETOF RECORD AS $$ BEGIN   IF i = 1 THEN