Add support for AT LOCAL

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Add support for AT LOCAL
Дата
Msg-id 8e25dec4-5667-c1a5-6581-167d710c2182@postgresfriends.org
обсуждение исходный текст
Ответы Re: Add support for AT LOCAL
Re: Add support for AT LOCAL
Список pgsql-hackers
The Standard defines time zone conversion as follows:

<datetime factor> ::=
   <datetime primary> [ <time zone> ]

<time zone> ::=
   AT <time zone specifier>

<time zone specifier> ::=
     LOCAL
   | TIME ZONE <interval primary>


While looking at something else, I noticed we do not support AT LOCAL. 
The local time zone is defined as that of *the session*, not the server, 
which can make this quite interesting in views where the view will 
automatically adjust to the session's time zone.

Patch against 3f1aaaa180 attached.
-- 
Vik Fearing
Вложения

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

Предыдущее
От: "Fujii.Yuki@df.MitsubishiElectric.co.jp"
Дата:
Сообщение: RE: Partial aggregates pushdown
Следующее
От: Richard Guo
Дата:
Сообщение: Re: postgres_fdw: wrong results with self join + enable_nestloop off