Thread: ...

HI,

Can someone pls help us with the following problem?

Any help would be appreciated.

Regards
-Naren.
Is stored procedures will return muliple rows in postgresql.If so a sample example is needed.








This message is proprietary to Hughes Software Systems Limited (HSS) and is
intended solely for the use of the individual to whom it is addressed.  It
may contain privileged or confidential information and should not be
circulated or used for any purpose other than for what it is intended.  If
you have received this message in error, please notify the originator
immediately.  If you are not the intended recipient, you are notified that
you are strictly prohibited from using, copying, altering, or disclosing
the contents of this message.  HSS accepts no responsibility for loss or
damage arising from the use of the information transmitted by this email
including damage from virus.

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
7.3 there are table functions. Look in the manual for examples with cursors -
also perhaps check Roberto Mello's plpgsql cookbook on
techdocs.postgresql.org

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

--  Richard Huxton