Re: Locale and LIKE matching

Daniel Serodio wrote:

> Hi! I'd like to know if the LIKE operator is locale-aware when
matching
> strings. Specifically, I'd like to have "... LIKE '%a%'" match "á"
(á)or
> "ã" (ã) (these are ISO8859-1, pt_BR chars). Is this possible? I've
> compiled postgresql 7.0.2 with --enable-locale --enable-multibyte,
and created
> the DB with latin1 encoding, but it still doesn't work as I'd like.
> TIA

I can feel your pain...

The LIKE operators and its wildcard characters are a misfeature of SQL
itself. Fortunately for us PostgreSQL has regular expressions as an
extension to SQL -- look
http://www.postgresql.org/users-lounge/docs/7.0/user/operators2123.htm.

I would do ~ '.*[aáã].*' or something like it. For documentation, try
man 5 regexp or at Emacs man regexp(5).

--
_
/ \ Leandro Guimarães Faria Corsetti Dutra +55 (11) 3040 8913
\ / Amdocs at Bell Canada +1 (514) 786 87 47
X Support Center, São Paulo, Brazil mailto:adbaamd(at)bell(dot)ca
/ \ http://terravista.pt./Enseada/1989/ mailto:leandrod(at)amdocs(dot)com