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

From: presnypreklad(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12046: lower_inf('(-infinity,today)'::tsrange) returns false
Date: 2014-11-24 11:34:06
Message-ID: 20141124113406.15510.64160@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 12046
Logged by: Nathan Cutler
Email address: presnypreklad(at)gmail(dot)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?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pmaseberg 2014-11-24 14:46:50 BUG #12048: Missing gdal packages for postgresql 9.4
Previous Message Tom Lane 2014-11-23 16:39:31 Re: BUG #12035: Prepared Transactions cannot be ROLLBACKed