Thread: 7.1.2 vs. INT8 indexes

When I create a table with an INT8 member and create an index on it,
a sequential scan is performed on select.

When I use INT, it uses the index.

Is there some trick to make this work, or am I just screwed?

Thanks :)

--Michael

Michael Graff <explorer@flame.org> writes:
> When I create a table with an INT8 member and create an index on it,
> a sequential scan is performed on select.

Cast the constant to int8 explicitly.

            regards, tom lane