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

From Andrew Dunstan
Subject Re: PATCH: make plpgsql IN args mutable (v1)
Date
Msg-id 4A724CC0.50208@dunslane.net
Whole thread Raw
In response to Re: PATCH: make plpgsql IN args mutable (v1)  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: PATCH: make plpgsql IN args mutable (v1)  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers

Jeff Davis wrote:
> If mutable IN parameters were allowed, I don't even think it could be
> allowable to call them from the SQL level, you could only from another
> function.
>
> For instance, what would it mean if you did something like:
>
> SELECT foo(a) FROM mytable;
>
> Where foo() mutated it's IN argument? Would that really be an UPDATE?
>
>
>   

No, surely the mutated value will only be visible within the scope of 
the function, i.e. it will be a purely local copy that gets altered.

cheers

andrew



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: PATCH: make plpgsql IN args mutable (v1)
Next
From: James Pye
Date:
Subject: Re: xpath not a good replacement for xpath_string