Re: [GENERAL] Unused Indexes

[Tim McAuley]

Mike Mascari wrote:

Tim McAuley wrote:
 

Hi,

I have a table which I have populated with over 5000 entries. There is a
combined  index placed on two of the columns (both bigint). I am trying
a simple select (i.e. select id where col1 = 1 and col2 = 1) covering
these  two columns and it keeps using a seq scan. Is this correct? I
would have thought that with this number of entries that an index scan
should be used.
   

You must cast the 1 to a bigint:

SELECT id WHERE col1 = 1::bigint AND col1 = 2::bigint

This should probably be listed under FAQ 4.8, but it isn't.
 

That's it!

I had actually just come across that before reading this email. It gets 
the explain back into shape anyway!

Thanks!

Tim



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly