pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

(no subject)
2+ messages / 2 participants
[nested] [flat]

* (no subject)
@ 2002-11-12 07:22 dnaren@hss.hns.com
  2002-11-12 10:19 ` Re: Richard Huxton <dev@archonet.com>
  0 siblings, 1 reply; 2+ messages in thread

From: dnaren@hss.hns.com @ 2002-11-12 07:22 UTC (permalink / raw)
  To: pgsql-sql



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.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re:
  2002-11-12 07:22 (no subject) dnaren@hss.hns.com
@ 2002-11-12 10:19 ` Richard Huxton <dev@archonet.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2002-11-12 10:19 UTC (permalink / raw)
  To: dnaren@hss.hns.com; pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2002-11-12 10:19 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-12 07:22  dnaren@hss.hns.com
2002-11-12 10:19 ` Re: Richard Huxton <dev@archonet.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox