On Mon, Sep 05, 2005 at 04:19:28PM +0200, Peter Eisentraut wrote:
> Am Montag, 5. September 2005 15:57 schrieb Aldor:
> > I want to get out a string only with characters A-Za-z.
> > Any idea how to do this in Postgres with POSIX Regex?
>
> Presumably,
>
> colname ~ '^[A-Za-z]*$'
>
> If you want to be independent of locale issues, then you'd have to enumerate
> all the letters instead of using a range specification.
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)
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"En las profundidades de nuestro inconsciente hay una obsesiva necesidad
de un universo lógico y coherente. Pero el universo real se halla siempre
un paso más allá de la lógica" (Irulan)
