Re: AT TIME ZONE correction

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: AT TIME ZONE correction
Дата
Msg-id 20180902032821.GB25700@momjian.us
обсуждение исходный текст
Ответ на Re: AT TIME ZONE correction  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: AT TIME ZONE correction  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
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" (which will not be subject to any further conversion when
> > it's displayed).
> > 
> > The existing text is indeed a bit deficient, because it fails to
> > draw a clear boundary between what the AT TIME ZONE operator is
> > doing and what is being done by the timestamp(tz) I/O functions.
> > But you're not making it better.
> 
> Yes, I am still researching and realize my diff is wrong.  Let me keep
> working and I will repost.

I have developed the attached patch, which I think is an improvement.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +

Вложения

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: AT TIME ZONE correction
Следующее
От: Tom Lane
Дата:
Сообщение: Re: AT TIME ZONE correction