Ravi wrote: > On Red Hat Enterprise Linux AS release 4 (Nahant Update 3) the milliseconds > returned is as follows > > -2209028400000 = -25567.458333333333333333333333333 = Jan 1 1900 > > On Red Hat Enterprise Linux AS release 3 (Taroon Update 3) the milliseconds > returned is as follows > -2208952800000 = -25566.583333333333333333333333333 = Jan 2 1900
Is one of these compiled with --enable-integer-datetimes, and the other not? You can tell by calling pg_controldata, IIRC. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
