Re: out parameters ( oracle 2 pg )

On Wed, 2002-11-06 at 01:33, Fred wrote:
> Hi,
>
> I am trying to convert some oracle stored procedures
> to plpgsql.
> One pb as many others encoutered, is that pgsql functions
> do not accept out parameters, neither multiple values within
> one return.
> Searching the list, I found 2 interesting posts :
> - one from Joshua Jore that uses "setof" but this seems not to
>   work with pgsql, just sql
>   -> http://archives.postgresql.org/pgsql-novice/2002-03/msg00046.php
>
> - another workaround from Art Nicewick that I tried successfully,
>   but what about the performances ...
>   -> http://archives.postgresql.org/pgsql-admin/2002-03/msg00166.php
>
> To summerize : are there any new helpful implemented functions,
> enhancements in pg or better workarounds (what about Art's one ?) ?
>

functions have been greatly enhanced to make returning sets of data
(multiple row/column) much easier in 7.3  You can download beta4 today
and test it out; RC1 is expected within the next week and final should
be out before thanksgiving.

Robert Treat