Re: function definition documentation

From: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: function definition documentation
Date: 2004-03-24 00:04:16
Message-ID: 71E37EF6B7DCC1499CEA0316A2568328DC9B6C@loki.wc.globexplorer.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Thanks muchly for the excellent tip. Lots of useful references there.

I seem to have battled through this thicket -- onwards !

Greg

-----Original Message-----
From: Richard Huxton [mailto:dev(at)archonet(dot)com]
Sent: Tuesday, March 23, 2004 12:09 AM
To: Gregory S. Williamson; pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] function definition documentation

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

Browse pgsql-sql by date

  From Date Subject
Next Message Bulatovic Natasa 2004-03-24 12:24:46 Invalid Unicode Character Sequence found
Previous Message Tom Lane 2004-03-23 22:37:10 Re: move forward 0 from foo;