The following bug has been logged online: Bug reference: 1609 Logged by: Oliver Siegmar Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org