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
--------
123
abz
abz123
(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 ===