pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedfunction definition documentation
3+ messages / 2 participants
[nested] [flat]
* function definition documentation
@ 2004-03-23 02:16 Gregory S. Williamson <gsw@globexplorer.com>
0 siblings, 1 reply; 3+ messages in thread
From: Gregory S. Williamson @ 2004-03-23 02:16 UTC (permalink / raw)
To: pgsql-sql
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.) ?
Thanks !
Greg Williamson
DBA
GlobeXplorer LLC
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: function definition documentation
@ 2004-03-23 08:08 Richard Huxton <dev@archonet.com>
parent: Gregory S. Williamson <gsw@globexplorer.com>
0 siblings, 0 replies; 3+ messages in thread
From: Richard Huxton @ 2004-03-23 08:08 UTC (permalink / raw)
To: Gregory S. Williamson <gsw@globexplorer.com>; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: function definition documentation
@ 2004-03-24 00:04 Gregory S. Williamson <gsw@globexplorer.com>
0 siblings, 0 replies; 3+ messages in thread
From: Gregory S. Williamson @ 2004-03-24 00:04 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; 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@archonet.com]
Sent: Tuesday, March 23, 2004 12:09 AM
To: Gregory S. Williamson; pgsql-sql@postgresql.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-03-24 00:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-23 02:16 function definition documentation Gregory S. Williamson <gsw@globexplorer.com>
2004-03-23 08:08 ` Richard Huxton <dev@archonet.com>
2004-03-24 00:04 Re: function definition documentation Gregory S. Williamson <gsw@globexplorer.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox