Re: Why data of timestamptz does not store value of timezone passed to it? - Mailing list pgsql-hackers

From David G Johnston
Subject Re: Why data of timestamptz does not store value of timezone passed to it?
Date
Msg-id CAKFQuwZZR+5898_oYvdQZCamyeHVK2jpw4Evsk+g6LnXWE9-9w@mail.gmail.com
Whole thread Raw
In response to Re: Why data of timestamptz does not store value of timezone passed to it?  (Greg Stark <stark@mit.edu>)
Responses Re: Why data of timestamptz does not store value of timezone passed to it?
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why data of timestamptz does not store value of timezone passed to it?
Next
From: Greg Stark
Date:
Subject: Re: Why data of timestamptz does not store value of timezone passed to it?