Is your int_value data type int4? If not then use "... from job_property
where int_value = '0'"
Indexes are used only if datatypes matches.

tried those variations already. Strange enough, after dropping and recreating the index everything worked fine.

Has that table been updated a lot in its life? If so, it may have had a problem with index bloat...

Try creating a partial index: create index blah on tablw where int_value=0;


---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

Reply via email to