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.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/