Re: Bug #848: Index on bigint column is unused in selects

On Sat, 2002-12-14 at 15:33, pgsql-bugs@postgresql.org wrote:
> PostgreSQL 7.2 will allways do a full table scan when the index field
> is a bigint. even with a "where bigkey = 99" clause.

This is a known problem: you need to enclose the integer literal in
single quotes, or cast it to int8 for the optimizer to consider an index
scan. i.e

select * from test1 where een = '99';

Cheers,

Neil