AT TIME ZONE INTERVAL and prepared statements

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема AT TIME ZONE INTERVAL and prepared statements
Дата
Msg-id Pine.BSO.4.56.0410221702490.18299@leary.csoft.net
обсуждение исходный текст
Ответы Re: AT TIME ZONE INTERVAL and prepared statements
Список pgsql-bugs
AT TIME ZONE INTERVAL $1 doesn't seem to be supported in prepared
statements.

This works:

SELECT now() AT TIME ZONE INTERVAL '-08:00';

This doesn't:

PREPARE mys(text) AS SELECT now() AT TIME ZONE INTERVAL $1;
ERROR:  syntax error at or near "$1" at character 57

These work:

PREPARE mys(interval) AS SELECT now() AT TIME ZONE $1;
PREPARE mys(text) AS SELECT now() AT TIME ZONE ($1::interval)


Any reason why the second case doesn't work?

Kris Jurka

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