"michael" <miblogic(at)yahoo(dot)com> 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