Re: LIKE/ESCAPE implementation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: Thomas Swan <tswan(at)olemiss(dot)edu>, Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LIKE/ESCAPE implementation
Date: 2000-08-06 05:03:09
Message-ID: 24097.965538189@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
>> I'd be inclined to force both strings to lower case as a whole and
>> then apply normal LIKE. Comments anyone?

> OK. "Both strings to lower case as a whole" doesn't seem to be something
> which is multibyte-enabled in our code. Am I just missing seeing some
> features?

Not sure that it matters for multibyte, but for sure LOCALE ought to
make a difference. Consider German esstet (sp?) --- that beta-looking
symbol that lowercases to "ss". Do we do this correctly?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-08-06 05:38:06 Re: LIKE/ESCAPE implementation
Previous Message Tom Lane 2000-08-06 04:57:05 Re: OK to remove operators for exp() and ln()