| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | Martin Chantler <MC44(at)acw(dot)co(dot)uk>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Stored Procedure Question |
| Date: | 2003-05-01 02:16:46 |
| Message-ID: | 20030501021646.GD30405@cc.usu.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, Apr 30, 2003 at 11:03:02AM -0700, Stephan Szabo wrote:
> On Wed, 30 Apr 2003, Martin Chantler wrote:
>
> > Hi all,
> >
> > I am confused about Postgres stored procedures (aka functions), can they
> > only return one value???
>
> They could return sets, but before 7.3 the usefulness was limited
>
> > All examples I have seen don't return a recordset
>
> You might want to see
> http://techdocs.postgresql.org/guides/SetReturningFunctions
Hmm, this is cool. I can think of a couple documents I could contribute to
this area over the summer.
Is there a mailing list one can sign up to to be informed of new content
in techdocs? That would be useful.
-Roberto
--
+----| Roberto Mello - http://www.brasileiro.net/ |------+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
CU = See You
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Dunajsky | 2003-05-01 03:07:50 | How to write an query to get this result? |
| Previous Message | Tom Lane | 2003-05-01 01:53:33 | Re: PERFORM / FOUND, what's up? |