Re: PATCH: make plpgsql IN args mutable (v1)

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: PATCH: make plpgsql IN args mutable (v1)
Дата
Msg-id 4A724CC0.50208@dunslane.net
обсуждение исходный текст
Ответ на Re: PATCH: make plpgsql IN args mutable (v1)  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: PATCH: make plpgsql IN args mutable (v1)  (Jeff Davis <pgsql@j-davis.com>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: PATCH: make plpgsql IN args mutable (v1)
Следующее
От: James Pye
Дата:
Сообщение: Re: xpath not a good replacement for xpath_string