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