Default to TIMESTAMP WITH TIME ZONE?

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Default to TIMESTAMP WITH TIME ZONE?
Дата
Msg-id CANbhV-G-n4bFmdzaOwiaq8pyDgyFod84dWd34N0QQzEJR0RCyA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Default to TIMESTAMP WITH TIME ZONE?  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
I heard the moan about "Why doesn't TIMESTAMP mean TIMESTAMP WITH TIME
ZONE" again today, so here is something concrete to address that.

AFAIK, SQL Standard requires the default to be WITHOUT TIME ZONE, but
nobody seems to think that is useful. We even added a specially
optimized ALTER TABLE command to make switching from WITHOUT to WITH
TIME ZONE easy, so it is clearly an important thing to solve.

So add a parameter called
   default_timestamp_with_timezone = off (default) | on

Thoughts?

-- 
Simon Riggs                http://www.EnterpriseDB.com/

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: John Naylor
Дата:
Сообщение: Re: badly calculated width of emoji in psql
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Default to TIMESTAMP WITH TIME ZONE?