Postgres Pro
Downloads
Home   >   mailing lists

Re: output parameters in functions? - Mailing list pgsql-novice

From Josh Berkus
Subject Re: output parameters in functions?
Date
Msg-id 200310101029.00874.josh@agliodbs.com
Whole thread Raw
In response to output parameters in functions?  (Aled Morris <aled@tesco.net>)
List pgsql-novice
Tree view 
Aled,

> So, is it possible to define output parameters in functions?

No.   Nobody's opposed to this ... it would most likely be part of a CREATE
PROCEDURE implementation ... but nothing is built or even in process.

I'd suggest using 7.3's SET RETURNING FUNCTIONS to return multiple values.
Check out  http://techdocs.postgresql.org/guides/SetReturningFunctions

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-novice by date:

Previous
From: "Derrick Betts"
Date:
Subject: Foreign key error...
Next
From: Oliver Fromme
Date:
Subject: Re: Foreign key error...