Daniel J. Summers wrote:
> Andrzej Zawadzki wrote:
>> Daniel J. Summers wrote:
>>> Tony Liao wrote:
>>>> I try to explain analyze,but it doesn't work ,it use seq scan.
>>> Generally speaking, LIKE doesn't use indexes.
>> ?! That's not true at all!!
> PostgreSQL (the great subject of this mailing list) doesn't do it with
> a standard index (5) - you've got to use a special operator class.
Please try... with "C" locales. Works out of the box.
In response to
pgsql-admin by date
|Next:||From: Tomasz Olszak||Date: 2009-02-26 13:56:32|
|Subject: Re: Re: Problem With using PERL::DBI in plperlu?==?UTF-8?Q? function|
|Previous:||From: Peter Hinse||Date: 2009-02-26 12:24:24|
|Subject: Re: lseek|