I need examples of stored procedures returning datasets

I need examples of stored procedures returning datasets.

Can anyone point me to some examples?

re: I need examples of stored procedures returning datasets

On Friday 12 September 2003 15:11, My Deja wrote:[color=blue]
> I need examples of stored procedures returning datasets.
>
> Can anyone point me to some examples?[/color]

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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

re: I need examples of stored procedures returning datasets

On Friday 12 September 2003 15:11, My Deja wrote:[color=blue]
> I need examples of stored procedures returning datasets.
>
> Can anyone point me to some examples?[/color]

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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

re: I need examples of stored procedures returning datasets

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).

--elein@varlena.com

On Fri, Sep 12, 2003 at 07:11:57AM -0700, My Deja wrote:[color=blue]
> 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[/color]

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

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

re: I need examples of stored procedures returning datasets

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).

--elein@varlena.com

On Fri, Sep 12, 2003 at 07:11:57AM -0700, My Deja wrote:[color=blue]
> 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[/color]

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

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