BUG #2953: index scan, feature request - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      2953
Logged by:          michael
Email address:      miblogic@yahoo.com
PostgreSQL version: 8.2.0
Operating system:   windows 2000
Description:        index scan, feature request
Details:

hi postgresql team,

can these be executed with index seek like what MS SQL does?

select * from account_category
where account_category_full_description <> 'MICHAEL'

this query resolves to sequential scan in postgres.

i saw ms sql, execution plan for the above query would become:

account_category_full_description < 'MICHAEL' or
account_category_full_description > 'MICHAEL'

thus it would utilize index scan

internally the above ms sql code would execute as:


select * from account_category
where account_category_full_description < 'MICHAEL'
or account_category_full_description > 'MICHAEL'


does my example warrant index scan?

thanks,
mike