Re: Add support for AT LOCAL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Add support for AT LOCAL
Дата
Msg-id 2287835.1697464481@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Add support for AT LOCAL  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: Add support for AT LOCAL  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Michael Paquier <michael@paquier.xyz> writes:
> Perhaps that's a stupid question..  But a server running under this
> environment fails the two following queries even for older branches,
> right?
> select timezone('UTC', '23:59:59.99-07'::timetz);
> select timezone('UTC', '23:59:00-07'::timetz);

One would expect, since the AT LOCAL syntax is just sugar for that.

I'm mighty tempted though to (a) add coverage for timetz_izone
to HEAD, and (b) backpatch the new tests, sans the AT LOCAL case,
to the back branches (maybe not v11).

            regards, tom lane



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: list of acknowledgments for PG16
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: BRIN minmax multi - incorrect distance for infinite timestamp/date