On 6/26/08, Craig James <craig_james(at)emolecules(dot)com> wrote:
> This seems like a bug to me, but it shows up as a performance problem.
> Since the column being queried is an integer, the second query (see below)
> can't possibly match, yet Postgres uses a typecast, forcing a full table
> scan for a value that can't possibly be in the table.
Which version are you using? 8.3 removes a lot of implicit casts (all?
not sure), so this may already be your fix.
Cheers,
Frank