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
>> RETURN QUERY SELECT 10,20 UNION ALL SELECT 30,40;
>> ELSE
>> RETURN QUERY SELECT 60,70 UNION ALL SELECT 80,90;
>> END IF;
>> RETURN;
>> END;
>> $$ LANGUAGE plpgsql;
>>
>> SELECT * FROM foo(1);
>> SELECT * FROM foo(2);
>>
>> Regards
>>
>> Pavel Stehule
>>
>
> FYI the OP is using 8.2 :) RETURN QUERY is 8.3+
sorry :)
then
RETURN QUERY query -->
DECLARE r record;
BEGIN
FOR r IN SELECT ....
RETURN NEXT r;
END FOR;
...
Regards
Pavel Stehule
>
> --
> Adrian Klaver
> adrian.kla...@gmail.com
>
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
