Re: 7.3 no longer using indexes for LIKE queries - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: 7.3 no longer using indexes for LIKE queries
Date
Msg-id Pine.LNX.4.44.0212092037110.25355-100000@localhost.localdomain
Whole thread Raw
In response to Re: 7.3 no longer using indexes for LIKE queries  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List pgsql-general
Hiroshi Inoue writes:

> For example, there could be case-insensitive collations.

You could do that, but normally you would take account the case
differences in the third pass.

Another interesting problem is how you would expect to handle
multicharacter collating elements that cross wildcard boundaries (like
'oc%' when 'ch' is a collating element).  That would give weird results.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-general by date:

Previous
From: Medi Montaseri
Date:
Subject: Re: UPDATE syntax problem
Next
From: Joe Conway
Date:
Subject: Re: table functions