As per conversation in #postgresql in freenode, it has been found that this seems to manifest on pgsql compiled using integer-datetime; float-datetime version does not have this problem.
<AndrewSN> easiest check for integer datetimes on 7.4 that I can find is: <AndrewSN> select encode(timestamptz_send('2000-01-01 00:00:01+00'),'hex'); <AndrewSN> 00000000000f4240 with integer timestamps <AndrewSN> 3ff0000000000000 with normal float timestamps <AndrewSN> the advantage [of integer timestamp] is that it gives a consistent resolution -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]