Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW] - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]
Date
Msg-id b42b73150909160849y678f5a79w76520d9053f1b20a@mail.gmail.com
Whole thread Raw
In response to Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]
List pgsql-hackers
On Wed, Sep 16, 2009 at 8:59 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Sep 16, 2009, at 8:37 AM, Andrew Dunstan <andrew@dunslane.net> wrote:
>
>>
>>
>> Abhijit Menon-Sen wrote:
>>>
>>> At 2009-07-30 13:37:16 -0700, prentice@cisco.com wrote:
>>>
>>>> This patch changes plpgsql IN parameters so they are mutable.
>>>>
>>>
>>> Makes sense, applies fine, works fine.
>>>
>>>
>>>
>>
>> How does this compare with PLSQL? I know in Ada an IN argument is in
>> effect a constant. I understand the utility, because I occasionally knock
>> against this restriction, but if it's incompatible with PLSQL I think we
>> should think about it more carefully.
>
> At worst it's an upward-compatible extension, or am I wrong?  If it's
> useful, which I think it is, what's the harm?

are we guarding against cases like:
select _foo, adjust_foo(_foo) from bar;  -- adjust_foo is inout

??
merlin


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Linux LSB init script
Next
From: Steve Prentice
Date:
Subject: Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]