Re: ILIKE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ILIKE
Date
Msg-id 4328.1046107844@sss.pgh.pa.us
Whole thread Raw
In response to Re: ILIKE  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: ILIKE
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Hey, I don't want to take your ILIKE away.  But at the time it was added
> the claim was that it was for compatibility and now we learn that that was
> wrong.  That is something to make people aware of, for example in the
> documentation.

It already does say

: The keyword ILIKE can be used instead of LIKE to make the match case
: insensitive according to the active locale. This is not in the SQL
: standard but is a PostgreSQL extension.

What else would you want to say?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: ILIKE
Next
From: Dave Cramer
Date:
Subject: Re: request for sql3 compliance for the update command