Frazer McLean <frazer@xxxxxxxxxxxxxxxxxx> writes: > I came across an unexpected comparison (tested on PostgreSQL 9.4 and > 9.6) for intervals with a large difference in magnitude. > '1 year'::interval > '32618665 years'::interval; > Is this a bug? It looks like the problem is overflow of the result of interval_cmp_value, because it's trying to compute =# select '32618665'::int8 * 30 * 86400 * 1000000; ERROR: bigint out of range It's not immediately obvious how to avoid that while preserving the same comparison semantics :-( regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
