On Tuesday 12 Nov 2002 7:22 am, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
