Postgres Pro
Downloads
Home   >   mailing lists

Re: Equality search on timestamp value returns no rows - Mailing list pgsql-general

From Tom Lane
Subject Re: Equality search on timestamp value returns no rows
Date
Msg-id 9949.1216844589@sss.pgh.pa.us
Whole thread Raw
In response to Equality search on timestamp value returns no rows  (Keaton Adams <kadams@mxlogic.com>)
List pgsql-general
Tree view 
Keaton Adams <kadams@mxlogic.com> 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

pgsql-general by date:

Previous
From: "Francisco Reyes"
Date:
Subject: Re: Any way to favor index scans, but not bitmap index scans?
Next
From: "Francisco Reyes"
Date:
Subject: Re: Any way to favor index scans, but not bitmap index scans?