Re: AT TIME ZONE correction

2018-09-01 Thread Bruce Momjian
On Sat, Sep 1, 2018 at 07:37:36PM -0400, Bruce Momjian wrote: > > Here we've got a time value that was initially given in EST (-05), > > but was converted to UTC by timestampz_in. Then the AT TIME ZONE > > says "Please convert this UTC value to MST, and emit it as a zoneless > > timestamp"

Re: AT TIME ZONE correction

2018-09-01 Thread Bruce Momjian
On Sat, Sep 1, 2018 at 07:30:43PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > Looking over the AT TIME ZONE docs, I think they are subtly confusing. > > The order of conversion specific in the first example should _start_ > > with the assumption of local time zone for the time stamp, not

Re: AT TIME ZONE correction

2018-09-01 Thread Tom Lane
Bruce Momjian writes: > Looking over the AT TIME ZONE docs, I think they are subtly confusing. > The order of conversion specific in the first example should _start_ > with the assumption of local time zone for the time stamp, not something > that happens after AT TIME ZONE is applied. The

AT TIME ZONE correction

2018-09-01 Thread Bruce Momjian
Looking over the AT TIME ZONE docs, I think they are subtly confusing. The order of conversion specific in the first example should _start_ with the assumption of local time zone for the time stamp, not something that happens after AT TIME ZONE is applied. The ordering in current docs makes the