Re: Default to TIMESTAMP WITH TIME ZONE?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Default to TIMESTAMP WITH TIME ZONE?
Дата
Msg-id CAKFQuwZXMYN3Fz5rbo5F=GY3=+DVg-9s6PwgyyE3dEzCf04Amg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Default to TIMESTAMP WITH TIME ZONE?  (Simon Riggs <simon.riggs@enterprisedb.com>)
Ответы Re: Default to TIMESTAMP WITH TIME ZONE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Default to TIMESTAMP WITH TIME ZONE?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Default to TIMESTAMP WITH TIME ZONE?