Re: Bug #897: EXTRACT(EPOCH FROM column): Possible wrong output

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug #897: EXTRACT(EPOCH FROM column): Possible wrong output
Дата
Msg-id 29470.1046381975@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bug #897: EXTRACT(EPOCH FROM column): Possible wrong output  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
I said:
> In most other contexts, we interpret such values as being in local time
> (the current server TimeZone) when it's necessary to make a distinction.
> Consistency would suggest doing it that way here too, I think.

I have applied a patch to make extract(epoch from timestamp) assume that
timestamps without time zone are in local time, and generate the correct
Unix epoch value accordingly.  This will appear in 7.3.3.

            regards, tom lane

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

Предыдущее
От: "Llew Sion Goodstadt"
Дата:
Сообщение: Re: psql -F problems
Следующее
От: Andrew Koshelev
Дата:
Сообщение: Optimizer bug in subselect