BUG #2953: index scan, feature request

From: "michael" <miblogic(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2953: index scan, feature request
Date: 2007-02-01 12:00:25
Message-ID: 200702011200.l11C0Ppm051827@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2953
Logged by: michael
Email address: miblogic(at)yahoo(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergiy Vyshnevetskiy 2007-02-01 13:23:30 Re: BUG #2948: default null values for not-null domains
Previous Message Peter Eisentraut 2007-02-01 08:23:16 Re: BUG #2948: default null values for not-null domains