BUG #12046: lower_inf('(-infinity,today)'::tsrange) returns false

Поиск
Список
Период
Сортировка
От presnypreklad@gmail.com
Тема BUG #12046: lower_inf('(-infinity,today)'::tsrange) returns false
Дата
Msg-id 20141124113406.15510.64160@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #12046: lower_inf('(-infinity,today)'::tsrange) returns false  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12046
Logged by:          Nathan Cutler
Email address:      presnypreklad@gmail.com
PostgreSQL version: 9.3.5
Operating system:   openSUSE 13.2
Description:

In the course of writing a program that accepts tsrange literals from the
user, which are then plugged into various SQL queries, today I was testing
some tsranges to see how they are interpreted by PostgreSQL 9.3.5.

This one, in particular, behaves strangely: '(-infinity,today)'::tsrange

The lower_inf function says the lower bound is not infinite (!)

test=> SELECT lower_inf('(-infinity,today)'::tsrange);
 lower_inf
-----------
 f
(1 row)

Yet PostgreSQL reports that this tsrange contains a timestamp like
'1000-01-01 BC' . . .

test=> SELECT '(-infinity,today)'::tsrange @> '1000-01-01 BC'::timestamp;
 ?column?
----------
 t
(1 row)

Seems like a bug?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #12035: Prepared Transactions cannot be ROLLBACKed
Следующее
От: pmaseberg@accuweather.com
Дата:
Сообщение: BUG #12048: Missing gdal packages for postgresql 9.4