"michael" <[EMAIL PROTECTED]> writes:
> can these be executed with index seek like what MS SQL does?
> select * from account_category
> where account_category_full_description <> 'MICHAEL'
What for? A query like that is generally going to fetch the majority of
the table, so an indexscan would be counterproductive.
It could potentially be a win if a very large fraction of the rows had
the exact value MICHAEL ... but the recommended way to deal with that is
to create a partial index with "full_description <> 'MICHAEL'" as the
WHERE clause.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
