Re: BUG #2107: Function INOUT parameter not returned to caller, - Mailing list pgsql-bugs

From Stallone
Subject Re: BUG #2107: Function INOUT parameter not returned to caller,
Date
Msg-id 439DA064.7080502@pobox.com
Whole thread Raw
In response to Re: BUG #2107: Function INOUT parameter not returned to caller, causes plpgsql malfunctions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> "Tony S" <tony@vectorsalad.com> writes:
>
>>Function defined with INOUT parameter.  Value of parameter is not returned
>>to calling function.
>
>
> You are confused about the meaning and use of INOUT.  It's not some kind
> of pass-by-reference parameter, it's just a shorthand for separate IN
> and OUT parameters.  In your example, the PERFORM discards the function
> result; the original value of 'outparameter' is not and cannot be
> modified by the called function.
>
>             regards, tom lane


This is very much my mistake.  I had indeed taken them to be a sort of
pass-by-reference parameter, and not part of the result definition,
which they actually are.  Running PERFORM is pointless, then, too.

pgsql-bugs by date:

Previous
From: "Jim Dew"
Date:
Subject: BUG #2112: query kills db thread
Next
From: "Michał Szeląg"
Date:
Subject: BUG #2109: NULL=NULL is false