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:[EMAIL PROTECTED] Sent: Tuesday, March 23, 2004 12:09 AM To: Gregory S. Williamson; [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
