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?
|
Список | pgsql-hackers |
On Fri, Aug 29, 2014 at 4:03 PM, Kevin Grittner <[hidden email]> wrote:I don't think the behaviour was standards-compliant in 7.2 either. For
> 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.
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 по дате отправления: