Quick Links

Re: POSIX Regular Expression question

From:	Peter Eisentraut <peter_e(at)gmx(dot)net>
To:	Aldor <an(at)mediaroot(dot)de>
Cc:	pgsql-sql(at)postgresql(dot)org
Subject:	Re: POSIX Regular Expression question
Date:	2005-09-05 14:19:28
Message-ID:	200509051619.29210.peter_e@gmx.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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/

In response to

POSIX Regular Expression question at 2005-09-05 13:57:06 from Aldor

Responses

Re: POSIX Regular Expression question at 2005-09-05 15:10:12 from A. Kretschmer
Re: POSIX Regular Expression question at 2005-09-05 15:13:31 from Alvaro Herrera
Re: POSIX Regular Expression question at 2005-09-05 15:40:37 from Harald Fuchs
Re: POSIX Regular Expression question at 2005-09-06 15:33:56 from Bruno Wolff III

Browse pgsql-sql by date

	From	Date	Subject
Next Message	A. Kretschmer	2005-09-05 15:10:12	Re: POSIX Regular Expression question
Previous Message	Michael Fuhr	2005-09-05 14:15:45	Re: POSIX Regular Expression question