Skip site navigation (1) Skip section navigation (2)

Re: function definition documentation

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 (view raw or flat)
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

In response to

pgsql-sql by date

Next:From: Marcel LooseDate: 2004-03-23 09:56:12
Subject: Newbie Query question
Previous:From: Achilleus MantziosDate: 2004-03-23 07:26:29
Subject: Re: special integrity constraints

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group