Thread

1. 7.1.2 vs. INT8 indexes

   Michael Graff <explorer@flame.org> — 2001-06-01T23:32:13Z

   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
   
   

2. Re: 7.1.2 vs. INT8 indexes

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-06-06T14:53:26Z

   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