| From: | Frazer McLean <frazer(at)frazermclean(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Unexpected interval comparison |
| Date: | 2017-03-21 13:57:09 |
| Message-ID: | 1490104629.422698.918452336.26FA96B7@webmail.messagingengine.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-03-21 14:42:16 | Re: Unexpected interval comparison |
| Previous Message | Michael Paquier | 2017-03-21 03:39:27 | Re: how can I use "pg_basebackup" and not include pg_log of master ? |