extract(epoch from infinity) is not 0

Поиск
Список
Период
Сортировка
От Daniele Varrazzo
Тема extract(epoch from infinity) is not 0
Дата
Msg-id CA+mi_8bda-Fnev9iXeUbnqhVaCWzbYhHkWoxPQfBca9eDPpRMw@mail.gmail.com
обсуждение исходный текст
Список pgsql-bugs
Hello,

=# select extract(epoch from 'infinity'::timestamp);
 date_part
-----------
         0

A better value would be 'infinity'::float8. Ditto for -infinity.

I'm trying to use a box-based index to represent the intervals in a
table containing a pair of fields date_from, date_to (timestamps),
where semi-open intervals are represented with +/- infinity. Building
the boxes using extract(epoch from ...) creates wrong entries as
semi-open intervals are converted into a box with a corner in (0,0).

-- Daniele

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

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Re: BUG #6113: SET DATESTYLE='European' does not set datestyle output correctly
Следующее
От: Sandro Santilli
Дата:
Сообщение: Ambiguos OPERATOR items in pg_restore manifest file (was: [postgis-devel] utils/new_postgis_restore.pl)