Skip site navigation (1) Skip section navigation (2)

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: 2004-05-28 20:54:50
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB34101AE43@Herge.rcsinc.local (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
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


Responses

pgsql-hackers by date

Next:From: Marc G. FournierDate: 2004-05-28 20:59:13
Subject: Re: Win32, PITR, nested transactions, tablespaces
Previous:From: Marc G. FournierDate: 2004-05-28 20:54:45
Subject: Re: Win32, PITR, nested transactions, tablespaces

pgsql-hackers-win32 by date

Next:From: Merlin MoncureDate: 2004-05-28 20:57:59
Subject: Re: could not locate my own executable path
Previous:From: Thomas SwanDate: 2004-05-28 20:48:32
Subject: could not locate my own executable path

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group