Corey Edwards wrote:

Your column is a bigint but 123 defaults to type int. Indexes aren't
used when there's a type mismatch. Use an explicit cast or quote it:

select * from bigtable where id = 123::bigint;


select * from bigtable where id = '123';

Thanks Corey, both of these do exactly what I need...


Mark Harrison
Pixar Animation Studios

---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Reply via email to