Re: Returning multiple values (but one row) in plpgsql

Karl O. Pinc wrote:
> Anybody got a better idea?  Anybody know just when
> this was fixed?  If I knew I might be able to see about
> getting our site upgraded.  (I tried looking in the CVS
> web interface, but was quickly daunted by the number of
> source files.)

select version();
                       version
-------------------------------------------------------------------------
  PostgreSQL 7.3.7 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7)
(1 row)

CREATE TYPE returntype AS (a INT, b INT);
CREATE OR REPLACE FUNCTION return_multiple()
    RETURNS setof returntype
    LANGUAGE plpgsql
    AS '
    DECLARE
      myvar returntype%rowtype;
    BEGIN
      myvar.a := 1;
      myvar.b := 2;
      RETURN NEXT myvar;
      RETURN;
    END;
';
SELECT * FROM return_multiple();
  a | b
---+---
  1 | 2
(1 row)

HTH,

Joe