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

From Robert Haas
Subject Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]
Date
Msg-id 5173F567-0B5D-4B6A-90A0-3242B070486D@gmail.com
Whole thread Raw
In response to Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]
List pgsql-hackers
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?

...Robert


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_hba.conf: samehost and samenet
Next
From: Andrew Dunstan
Date:
Subject: Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]