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