Am Montag, 5. September 2005 17:13 schrieb Alvaro Herrera:
> Note that [:alpha:] and such character classes are defined by POSIX to
> be locale independent:
>
> alvherre=# select 'á' ~ '[a-z]';
> ?column?
> ----------
> f
> (1 fila)
>
> alvherre=# select 'á' ~ '[[:alpha:]]';
> ?column?
> ----------
> t
> (1 fila)
I don't think this addresses the concern I intended to raise. The first query
should succeed for all letters between a and z, the second should succeed for
all letters. Neither is guaranteed to succeed only for all "normal" Latin
letters a, b, c, ... z.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/