DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=EiyclNduKCILjGG2qFnB5YSQ/ogp2qH24PVfxcHDelNsV8e7YKuhZ/M6oKlfYLGgOGVO2FQLDWo6YQHQk/z8UYC3Lk93xVa2x4mRiHTckqgKOuXhmn8n4MNs8U2UbzPkfVFN8NlBY694jS/ko1R6RuEp7Jm2wsD39OP737onOMw=
Message-ID: <6d8daee3050722111118944657@mail.gmail.com>
Date: Fri, 22 Jul 2005 11:11:09 -0700
From: Tony Wasson <ajwasson@gmail.com>
Reply-To: Tony Wasson <ajwasson@gmail.com>
To: jim@contactbda.com
Subject: Re: Multi-column returns from pgsql
Cc: "Mark R. Dingee" <mark.dingee@cox.net>, pgsql-sql@postgresql.org
In-Reply-To: <20050722165558.M96628@contactbda.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <200507221149.21550.mark.dingee@cox.net>
	<20050722165558.M96628@contactbda.com>

On 7/22/05, Jim Buttafuoco <jim@contactbda.com> wrote:
> Mark,
>=20
> Instead of  RETURN NEXT rec.txt1; RETURN NEXT rec.txt2; just use RETURN N=
EXT rec;
>=20
> then your select statement would be
> select * from my_func() as (txt1 text,txt2 text);
>=20
> Jim

Besides a simple RETURN NEXT, you'll need to return a SETOF some
composite type. You can do something like

CREATE TYPE twotexts_t AS (txt1 TEXT, txt2 TEXT);=20

CREATE OR REPLACE FUNCTION my_func() returns SETOF twotexts_t AS '
DECLARE
   rec record;
BEGIN
   FOR rec IN SELECT txt1, txt2 FROM mytable LOOP
      RETURN NEXT
   END LOOP;
   RETURN;
END;' language 'plpgsql';