7.1.2 vs. INT8 indexes

Started by Michael Graffalmost 25 years ago2 messagesgeneral
Jump to latest
#1Michael Graff
explorer@flame.org

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Michael Graff (#1)
Re: 7.1.2 vs. INT8 indexes

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