Re: returning multiple result sets from a stored procedure - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: returning multiple result sets from a stored procedure
Date
Msg-id 4C8906C602000025000354A7@gw.wicourts.gov
Whole thread Raw
In response to Re: returning multiple result sets from a stored procedure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: returning multiple result sets from a stored procedure
Next
From: Darren Duncan
Date:
Subject: Re: returning multiple result sets from a stored procedure