| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: function definition documentation |
| Date: | 2004-03-23 08:08:56 |
| Message-ID: | 200403230808.57253.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Tuesday 23 March 2004 02:16, Gregory S. Williamson wrote:
> I am having an impossible time porting some simple Stored Procedures from
> Informix to postgres. The documentation is almost self defeating.
>
> Are there any better descriptions of how to define functions that return
> several tuples to a wide variety of calling programs (e.g. I can't count on
> my users running the psql command line tool, but rather coldfusion, jsp
> etc.) ?
You might want to look at the "Set Returning Functions" at the techdocs site:
http://techdocs.postgresql.org
Most of your problems are down to quoting issues and misleading error
statements.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcel Loose | 2004-03-23 09:56:12 | Newbie Query question |
| Previous Message | Achilleus Mantzios | 2004-03-23 07:26:29 | Re: special integrity constraints |