Re: Proposal: OUT parameters for plpgsql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposal: OUT parameters for plpgsql
Date
Msg-id 3593.1111454999@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposal: OUT parameters for plpgsql  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: Proposal: OUT parameters for plpgsql  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Gavin Sherry <swm@linuxworld.com.au> writes:
>> Tom Lane <tgl@sss.pgh.pa.us> writes:
>>> (When there is just one, should the default be to return that type
>>> rather than a one-column RECORD?)

> ANSI SQL allows at most one OUT parameter for a function (which can be
> used instead of having the function return a value via the usual means).

OK, so that answers my question above: a single OUT parameter should be
equated to an ordinary return value, not a RECORD, so as to emulate this
aspect of the spec.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: Proposal: OUT parameters for plpgsql
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Proposal: OUT parameters for plpgsql