Is this expected behavior or a bug?
=> select version();
version
------------------------------------------------------------------------------------------------
PostgreSQL 8.2.4 on i386-portbld-freebsd6.2, compiled by GCC cc (GCC)
3.4.6 [FreeBSD] 20060305
(1 row)
=> select '2000000000 hours'::interval + '2000000000 hours'::interval;
?column?
--------------------------
-1124095576:01:49.551616
(1 row)
Regards,
Jeff Davis
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
