Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
select like...not using index
- From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
- To: <pgsql-hackers(at)postgresql(dot)org>
- Cc: "PgSql-Win32" <pgsql-hackers-win32(at)postgresql(dot)org>
- Subject: select like...not using index
- Date: Fri, 28 May 2004 16:54:50 -0400
- Message-id: <6EE64EF3AB31D5448D0007DD34EEB34101AE43(at)Herge(dot)rcsinc(dot)local>
Sometime between yesterday and today queries in the form of "select * from t where t.f like 'k%'" have been broken so that they never use the index (on win32, not sure about others). On win32, at least, they have been broken for a while but this was due to a known issue based on the locales. AFAICT, the current cvs has addressed this issue and (show lc_collate returns C) there seems to be no reason why the queries aren't working properly. Merlin
- Follow-Ups:
- Re: select like...not using index
- From: Tom Lane
- Re: [HACKERS] select like...not using index
- From: pgsql
- Re: select like...not using index
- Prev by Date: could not locate my own executable path
- Next by Date: Re: could not locate my own executable path
- Previous by thread: could not locate my own executable path
- Next by thread: Re: [HACKERS] select like...not using index
- Indexes: