The following bug has been logged online: Bug reference: 2953 Logged by: michael Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
