Re: [BUGS] BUG #2953: index scan, feature request

2007-02-02 Thread Magnus Hagander
On Thu, Feb 01, 2007 at 09:17:51PM -0500, Tom Lane wrote: > "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 genera

Re: [BUGS] BUG #2953: index scan, feature request

2007-02-01 Thread Tom Lane
"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

[BUGS] BUG #2953: index scan, feature request

2007-02-01 Thread michael
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 wit