Re: clarification of timestamp

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: clarification of timestamp
Дата
Msg-id 3CCD7711.9937357F@fourpalms.org
обсуждение исходный текст
Ответ на clarification of timestamp  (Olivier PRENANT <ohp@pyrenet.fr>)
Ответы Re: clarification of timestamp  (Olivier PRENANT <ohp@pyrenet.fr>)
Список pgsql-hackers
> My problem was that on my 7.1.3 db, I have timestamp columns with
> fonctinal indices as date(column).
> Thes indices (indexes) wont work anymore because they're not marked loosy.
> I've been told that I should go for timestamp without timezone instead,
> witch is okay because all timezones are the same. However, what happens
> with daylight saving calculations. Is it still take into account??

No, because there is no time zone to think about. What daylight savings
calculations would you need to consider? I'm a big believer in making
databases time zone aware, but if everything really is happening within
the same time zone then your application should probably not notice an
effect.
                  - Thomas


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

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: Vote totals for SET in aborted transaction
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Vote totals for SET in aborted transaction