I need examples of stored procedures returning datasets

[My Deja]

I need examples of stored procedures returning datasets.

Can anyone point me to some examples?

[Richard Huxton]

On Friday 12 September 2003 15:11, My Deja wrote:

I need examples of stored procedures returning datasets.

Can anyone point me to some examples?

There are some in the contrib directory of the source distribution
(contrib/tablefunc iirc) and also check http://techdocs.postgresql.org -
there is a good article there showing their use.
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Richard Huxton]

On Friday 12 September 2003 15:11, My Deja wrote:

I need examples of stored procedures returning datasets.

Can anyone point me to some examples?

There are some in the contrib directory of the source distribution
(contrib/tablefunc iirc) and also check http://techdocs.postgresql.org -
there is a good article there showing their use.
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[elein]

There is are several articles on the subject in
General Bits in issue #26 (http://www.valena.com/GeneralBits/26.html)
The code for the discussion in the articles is available
in the Tidbits area (http://www.varlena.com/GeneralBits/Tidbits).

--*****@varlena.com

On Fri, Sep 12, 2003 at 07:11:57AM -0700, My Deja wrote:

I need examples of stored procedures returning datasets.

Can anyone point me to some examples?

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[elein]

There is are several articles on the subject in
General Bits in issue #26 (http://www.valena.com/GeneralBits/26.html)
The code for the discussion in the articles is available
in the Tidbits area (http://www.varlena.com/GeneralBits/Tidbits).

--*****@varlena.com

On Fri, Sep 12, 2003 at 07:11:57AM -0700, My Deja wrote:

I need examples of stored procedures returning datasets.

Can anyone point me to some examples?

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html