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

• Re: LIKE/ESCAPE implementation at 2000-08-06 04:51:05 from Thomas Lockhart

Responses

• Re: LIKE/ESCAPE implementation at 2000-08-06 05:38:06 from Thomas Lockhart

pgsql-hackers by date

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