Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I don't understand the point of a RETURN value when there can be
> no caller to return a value to.
The version of the draft standard I last saw allowed something like:
SET x = CALL sp(param_a, param_b);
I seem to remember Sybase supported a return value as well as OUT
parameters, too; I think there it was limited to integer values and
was conventionally used to indicate overall success or failure of
the procedure.
-Kevin
In response to
pgsql-hackers by date
| Next: | From: Darren Duncan | Date: 2010-09-09 21:12:24 |
| Subject: Re: returning multiple result sets from a stored procedure |
| Previous: | From: Tom Lane | Date: 2010-09-09 21:07:41 |
| Subject: Re: returning multiple result sets from a stored procedure |