On Sat, 2002-12-14 at 15:33, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
