BUG #2592: ILIKE does not care about locales

The following bug has been logged online:

Bug reference: 2592
Logged by: Robert Siemer
Email address: Robert(dot)Siemer-postgresql(dot)org(at)backsla(dot)sh
PostgreSQL version: 8.1.4
Operating system: Linux
Description: ILIKE does not care about locales
Details:

Hi!

As I don't want to risk getting things mixed up here in this very report,
lets assume:
s and t are strings with one 'international' character, one having the lower
case the other upper

lower(s) LIKE lower(t) yields True, as it should

s ILIKE t yields False --> I expect True

I tried this with LC_COLLATE=C and the rest LC_...=es_ES.utf8

dennisb from irc reported LC_everything=sv_SE.UTF-8 with version 8.1.0
having the same problems.

Some "non-normative" examples for s and t:
http://rafb.net/paste/results/bMRfez77.html
and , ,