Horton

Re: ILIKE

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Vince Vielhaber <vev@michvhf.com>, Josh Berkus <josh@agliodbs.com>, pgsql-hackers@postgresql.org
Date: 2003-02-24T17:30:44Z
Lists: 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