On 2008-07-23 21:24, Keaton Adams wrote:
> We run into a problem when an equality search on a timestamp column
> returns no records, even when there are records to return, as in this
> example:
>
> mxl=# select * from mxl_scheduler_queue where status_modified =
> '2008-07-03 16:55:06.44695-06';
Keaton Adams <[EMAIL PROTECTED]> writes:
> Any ideas why the equality search wouldn't work in the first case, but after
> reloading the table data it works just fine?
I think you're using floating-point timestamps and encountering a
roundoff issue.
regards, tom lane
--
PostgreSQL 8.1.4
RHEL 4.x
So we have run into an interesting problem I want to know if anyone else has
encountered before. We have a scheduler process that 'hangs' on occasion and
we have isolated the issue to Postgres not returning any records when there are
actual records to return. Here i
