The following bug has been logged online:
Bug reference: 1609
Logged by: Oliver Siegmar
Email address: oliver(at)siegmar(dot)net
PostgreSQL version: 8.0.2
Operating system: Linux
Description: Bug in interval datatype for 64 Bit timestamps
Details:
Postgres compiled with --enable-integer-datetimes has a bug in interval
datatype representation -
select '10.10 secs ago'::interval;
interval
-------------------
@ 10.-10 secs ago
(1 row)
Without --enable-integer-datetimes -
interval
------------------
@ 10.10 secs ago
(1 row)
Please CC me, because I'm not on the list.
Oliver