Re: LIKE/ESCAPE implementation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: LIKE/ESCAPE implementation
Date
Msg-id 24097.965538189@sss.pgh.pa.us
Whole thread Raw
In response to Re: LIKE/ESCAPE implementation  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: OK to remove operators for exp() and ln()
Next
From: Thomas Lockhart
Date:
Subject: Re: LIKE/ESCAPE implementation