From: Frazer McLean <frazer@frazermclean.co.uk>
To: pgsql-general@postgresql.org
Subject: Unexpected interval comparison
Date: Tue, 21 Mar 2017 14:57:09 +0100
Message-ID: <1490104629.422698.918452336.26FA96B7@webmail.messagingengine.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
I came across an unexpected comparison (tested on PostgreSQL 9.4 and
9.6) for intervals with a large difference in magnitude.
I narrowed it down to this example, where comparisons with this range
give the wrong value:
postgres=# SELECT
'1 year'::interval > '3854933 years'::interval,
'1 year'::interval > '3854934 years'::interval,
'1 year'::interval > '32618664 years'::interval,
'1 year'::interval > '32618665 years'::interval;
?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
f | t | t | f
(1 row)
Is this a bug? Should I not be comparing intervals? It would seem the
interval type has enough information to give the correct answer here.
Regards,
Frazer McLean
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: frazer@frazermclean.co.uk
Subject: Re: Unexpected interval comparison
In-Reply-To: <1490104629.422698.918452336.26FA96B7@webmail.messagingengine.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox