Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: dnaren@hss.hns.com, pgsql-sql@postgresql.org
Subject: Re: 
Date: Tue, 12 Nov 2002 10:19:48 +0000
User-Agent: KMail/1.4.3
References: <65256C6F.00287EB4.00@sampark.hss.hns.com>
In-Reply-To: <65256C6F.00287EB4.00@sampark.hss.hns.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200211121019.49225.dev@archonet.com>

On Tuesday 12 Nov 2002 7:22 am, dnaren@hss.hns.com wrote:
> HI,
>
> Can someone pls help us with the following problem?
>
> Any help would be appreciated.
>
>  Is stored procedures will return muliple rows in postgresql.
>  If so a sample example is needed.

With current versions of PG, look into returning a cursor from plpgsql. For=
=20
7.3 there are table functions. Look in the manual for examples with cursors=
 -=20
also perhaps check Roberto Mello's plpgsql cookbook on=20
techdocs.postgresql.org=20

Table functions might well be documented in the developer's version of the=
=20
manual but there are definitely examples in the contrib/ directory of the=
=20
source download (of 7.3). I seem to remember an example in the mailing list=
s=20
too, so perhaps a check of the archives would be worthwhile.

--=20
  Richard Huxton