Re: BUG #2542: ALTER USER foo SET bar = func(baz) errors out

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #2542: ALTER USER foo SET bar = func(baz) errors out
Дата
Msg-id 14692.1153449987@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #2542: ALTER USER foo SET bar = func(baz) errors out  ("David Fetter" <david@fetter.org>)
Ответы Re: BUG #2542: ALTER USER foo SET bar = func(baz) errors out  (David Fetter <david@fetter.org>)
Список pgsql-bugs
"David Fetter" <david@fetter.org> writes:
> is there some way to let the right hand side of SET be the (TEXT) output of
> a function?

No.  SET is a utility command and utility commands generally don't do
expression evaluation.  (There are some specific reasons why not for
SET, but I won't get into that here.)

However, you can get the desired effect in various other ways; see the
set_config() function, or try updating the pg_settings view ...

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David Fetter"
Дата:
Сообщение: BUG #2542: ALTER USER foo SET bar = func(baz) errors out
Следующее
От: David Fetter
Дата:
Сообщение: Re: BUG #2542: ALTER USER foo SET bar = func(baz) errors out