Re: Default to TIMESTAMP WITH TIME ZONE? - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Default to TIMESTAMP WITH TIME ZONE?
Date
Msg-id CAKFQuwZXMYN3Fz5rbo5F=GY3=+DVg-9s6PwgyyE3dEzCf04Amg@mail.gmail.com
Whole thread Raw
In response to Re: Default to TIMESTAMP WITH TIME ZONE?  (Simon Riggs <simon.riggs@enterprisedb.com>)
Responses Re: Default to TIMESTAMP WITH TIME ZONE?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Aug 13, 2021 at 9:28 AM Simon Riggs <simon.riggs@enterprisedb.com> wrote:

The only hope is to eventually change the default, so probably
the best thing is to apply pressure via the SQL Std process.


Then there is no hope because this makes the situation worse.

If anything I'd suggest the SQL standard should probably just admit this "default behavior of timestamp" is a bad idea and deprecate its existence.  IOW, the only two standard conforming syntaxes are the explicit WITH/WITHOUT TIME ZONE ones.  Any database implementation that implements "timestamp" as a type alias is doing so in an implementation dependent way.  Code that wants to be SQL standard conforming portable needs to use the explicit types.

David J.

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Default to TIMESTAMP WITH TIME ZONE?
Next
From: Tom Lane
Date:
Subject: Re: Default to TIMESTAMP WITH TIME ZONE?