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 |