| Lists: | Postg토토SQL : Postg토토SQL |
|---|
| From: | mydejamail(at)yahoo(dot)co(dot)uk (My Deja) |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | I need examples of stored procedures returning datasets |
| Date: | 2003-09-12 14:11:57 |
| Message-ID: | 90acdc45.0309120611.134ba0fd@posting.google.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg토토SQL : Postg토토SQL |
I need examples of stored procedures returning datasets.
Can anyone point me to some examples?
| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | mydejamail(at)yahoo(dot)co(dot)uk (My Deja), pgsql-general(at)postgresql(dot)org |
| Subject: | Re: I need examples of stored procedures returning datasets |
| Date: | 2003-09-13 20:17:58 |
| Message-ID: | 200309132117.58764.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | elein <elein(at)varlena(dot)com> |
|---|---|
| To: | My Deja <mydejamail(at)yahoo(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: I need examples of stored procedures returning datasets |
| Date: | 2003-09-13 21:23:25 |
| Message-ID: | 20030913142325.B12497@cookie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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(at)varlena(dot)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