Re: BUG #5192: --disable-integer-datetimes changes timestamp comparison behavior

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thomas S(dot) Chin" <thom(at)photoshelter(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5192: --disable-integer-datetimes changes timestamp comparison behavior
Date: 2009-11-16 20:59:18
Message-ID: 7437.1258405158@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Thomas S. Chin" <thom(at)photoshelter(dot)com> writes:
> Description: --disable-integer-datetimes changes timestamp comparison
> behavior

This is not a bug. Float timestamps are inherently not infinitely
precise, but your test case expects them to be accurate to the
microsecond.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2009-11-16 21:20:16 Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"
Previous Message Tom Lane 2009-11-16 20:54:23 Re: BUG #5191: now() returns same value from Perl.