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.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
>