Add support for AT LOCAL - Mailing list pgsql-hackers

From Vik Fearing
Subject Add support for AT LOCAL
Date
Msg-id 8e25dec4-5667-c1a5-6581-167d710c2182@postgresfriends.org
Whole thread Raw
Responses Re: Add support for AT LOCAL  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Add support for AT LOCAL  (Daniel Gustafsson <daniel@yesql.se>)
List 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
Attachment

pgsql-hackers by date:

Previous
From: "Fujii.Yuki@df.MitsubishiElectric.co.jp"
Date:
Subject: RE: Partial aggregates pushdown
Next
From: Richard Guo
Date:
Subject: Re: postgres_fdw: wrong results with self join + enable_nestloop off