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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Ed L."
Дата:
Сообщение: Re: [Slony1-general] Thread-safety detection on HP-UX
Следующее
От: Tom Lane
Дата:
Сообщение: Re: AT TIME ZONE INTERVAL and prepared statements