On Mon, Sep 05, 2005 at 16:19:28 +0200,
Peter Eisentraut <peter_e(at)gmx(dot)net> 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.
Or use:
colname ~ '^[[:alpha:]]*$'