Re: Need help with INOUT mis-understanding - Mailing list pgsql-general

From Tony Caduto
Subject Re: Need help with INOUT mis-understanding
Date
Msg-id 435FF693.6040309@amsoftwaredesign.com
Whole thread Raw
In response to Re: Need help with INOUT mis-understanding  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Need help with INOUT mis-understanding
Re: Need help with INOUT mis-understanding
List pgsql-general
Tom Lane wrote:

>Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:
>
>
>>I have noticed this as well, if I declare OUT params I can modify them
>>to my hearts content before they go out,
>>however if you declare it as a INOUT you can't modify it because it is
>>declared as a constant.
>>
>>
>
>Uh, I don't think so.
>
>                    /* input argument vars are forced to be CONSTANT */
>                    if (argmode == PROARGMODE_IN)
>                        ((PLpgSQL_var *) argvariable)->isconst = true;
>
>Can you provide a test case that misbehaves that way?
>
>            regards, tom lane
>
>
>
Tom,
Maybe we are mis-communicating here.
So what you are saying is INOUT params are NOT constants and you can
modify them in the function body?
I could have sworn that did not work for me in beta1, I will try it
again in beta 4 and see if things have changed.

Thanks,

Tony Caduto

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error Message
Next
From: Tom Lane
Date:
Subject: Re: Need help with INOUT mis-understanding