Re: 7.3 no longer using indexes for LIKE queries

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Matthew Gabeler-Lee <mgabelerlee(at)zycos(dot)com>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: 7.3 no longer using indexes for LIKE queries
Date: 2002-12-09 19:49:44
Message-ID: Pine.LNX.4.44.0212092037110.25355-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-12-09 20:57:41 Re: doc fix for OS/X (was: 7.3 on OS X HOWTO)
Previous Message Medi Montaseri 2002-12-09 19:33:53 Re: UPDATE syntax problem