Question on utility statements and parameterization

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Question on utility statements and parameterization
Дата
Msg-id CAKt_ZfvGcw3NG49bAnoy9nxO=XvvC9cwNeXUPmaYDuH8wkEN-Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Question on utility statements and parameterization  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
Hi all;

As I understand, utility statements are not generally parameterized, so:

postgres=# alter user test123 with password 'foo' valid until now() +
'1 day'::interval;
ERROR:  syntax error at or near "now"
LINE 1: ...lter user test123 with password 'foo' valid until now() + '1...

Is this by design?  If so, what is the reason?  If not, what would
have to be done to change this?

Best Wishes,
Chris Travers

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

Предыдущее
От: Antonio Vieiro
Дата:
Сообщение: Re: Detecting memory leaks with libpq?
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Question on utility statements and parameterization