Re: POSIX Regular Expression question

am  05.09.2005, um 14:57:06 +0100 mailte Aldor folgendes:
> Hi,
> 
> I want to get out a string only with characters A-Za-z.

like this?

test=# select * from foo;  s
--------123abzabz123
(3 rows)

test=# select * from foo where s ~ '^[a-zA-Z]+$'; s
-----abz
(1 row)


> Any idea how to do this in Postgres with POSIX Regex?

The term '[a-zA-Z]+' means: this chars at least one times, the '^' and
'$' are anchors to the begin and end of the line.

Hope that helps,


Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===