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

From Steve Prentice
Subject Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]
Date
Msg-id C1A58669-30CE-453F-A3B1-9833BE44A4BC@cisco.com
Whole thread Raw
In response to Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On Sep 16, 2009, at 8:49 AM, Merlin Moncure wrote:
> On Wed, Sep 16, 2009 at 8:59 AM, Robert Haas <robertmhaas@gmail.com>  
> wrote:
>> 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

Two things:

1) the patch only affects IN parameters,

2) the parameter is a local copy and doesn't affect parameters/ 
variables outside of its scope.



pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]
Next
From: Jeff Davis
Date:
Subject: Re: WIP: generalized index constraints