Re: Why data of timestamptz does not store value of timezone passed to it?

Поиск
Список
Период
Сортировка
От David G Johnston
Тема Re: Why data of timestamptz does not store value of timezone passed to it?
Дата
Msg-id CAKFQuwZZR+5898_oYvdQZCamyeHVK2jpw4Evsk+g6LnXWE9-9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why data of timestamptz does not store value of timezone passed to it?  (Greg Stark <stark@mit.edu>)
Ответы Re: Why data of timestamptz does not store value of timezone passed to it?  (Greg Stark <stark@mit.edu>)
Список pgsql-hackers
On Fri, Aug 29, 2014 at 11:12 AM, Greg Stark [via PostgreSQL] <[hidden email]> wrote:
On Fri, Aug 29, 2014 at 4:03 PM, Kevin Grittner <[hidden email]> wrote:
> It was actually rather disappointing to hear that we had a
> conforming implementation and changed away from it circa the 7.2
> release; and even more disturbing to hear that decision is still
> being defended on the grounds that there's no point providing
> standard conforming behavior if we can think of different behavior
> that we feel is more useful.  We should have both.

I don't think the behaviour was standards-compliant in 7.2 either. For
that matter, I can't think of any circumstance where the standard
behaviour is useful. There's absolutely no way to write correct code
using it.



​And forcing people to change their data types to migrate to PostgreSQL is undesirable IF our type is usefully equivalent to others in the majority of situations - though I don't know if that is actually the case.​

David J.


View this message in context: Re: Why data of timestamptz does not store value of timezone passed to it?
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Why data of timestamptz does not store value of timezone passed to it?
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Why data of timestamptz does not store value of timezone passed to it?