Re: Possible solution for LIKE optimization - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: Possible solution for LIKE optimization
Date
Msg-id 3B6E44F7.68457C2@tpf.co.jp
Whole thread Raw
In response to Re: Possible solution for LIKE optimization  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Possible solution for LIKE optimization
List pgsql-hackers
Tom Lane wrote:
> 
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Wait, why isn't that the solution in the first place.  Let's build the
> > index with an opclass that uses plain strcmp comparison.
> 
> By George, I think you've got it!  All we need is comparison ops and
> an opclass that use strcmp, even when USE_LOCALE is defined.  Then we
> document "here's how you make a LIKE-compatible index in non-ASCII
> locales", and away we go.
> 

Do we have to make 2 indexes for non_ASCII text field ?

regards,
Hiroshi Inoue


pgsql-hackers by date:

Previous
From: Grant
Date:
Subject: Vim!
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: AW: partial index