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.Nix@sfsltd.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
>