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

From Greg Stark
Subject Re: Why data of timestamptz does not store value of timezone passed to it?
Date
Msg-id CAM-w4HPtRb3BOfgARVeD8ka1Li=Z7H6W8mBMP=a-P=EvM3wkmw@mail.gmail.com
Whole thread Raw
In response to Re: Why data of timestamptz does not store value of timezone passed to it?  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: Why data of timestamptz does not store value of timezone passed to it?
List pgsql-hackers
On Fri, Aug 29, 2014 at 4:03 PM, Kevin Grittner <kgrittn@ymail.com> 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.


-- 
greg



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Why data of timestamptz does not store value of timezone passed to it?
Next
From: Michael Paquier
Date:
Subject: Re: Misleading error message in logical decoding for binary plugins