Re: Functions that return both Output Parameters and recordsets

Hello

it's possible, but it's probably some different than you expect

CREATE OR REPLACE FUNCTION foo(OUT a integer, OUT b integer)
RETURNS SETOF RECORD AS $$
BEGIN
a := 10; b := 10;
RETURN NEXT;
a := 11; b := 20;
RETURN NEXT;
RETURN;
END;
$$ LANGUAGE plpgsql;

postgres=# select * from foo();
a | b
----+----
10 | 10
11 | 20
(2 rows)

Regards
Pavel Stehule

2007/6/11, Jeremy Nix <Jeremy(dot)Nix(at)sfsltd(dot)com>:
> Is this possible? I'm attempting to create a function like this and I'm
> getting the following error:
>
> ERROR: RETURN NEXT cannot have a parameter in function with OUT
> parameters at or near "myRecord".
>
> --
>
> __________________________________
> Jeremy Nix
> Senior Application Developer
> Southwest Financial Services, Ltd.
> (513) 621-6699
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>