Postgres Pro
Downloads
Home   >   mailing lists

Re: Method to detect certain characters in column? - Mailing list pgsql-general

From Tom Lane
Subject Re: Method to detect certain characters in column?
Date
Msg-id 4568.1214263085@sss.pgh.pa.us
Whole thread Raw
In response to Method to detect certain characters in column?  ("Ian Meyer" <ianmmeyer@gmail.com>)
List pgsql-general
Tree view 
"Ian Meyer" <ianmmeyer@gmail.com> writes:
> So I have a column that contains usernames that have characters such
> as �(c)(R), for example: fuch�(c)r.. is there any way to find names
> with non A-Za-z0-9?

Hmm, none of the responses so far look right to me.  How about

    WHERE NOT (col ~ '^[A-Za-z0-9]*$')

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Method to detect certain characters in column?
Next
From: Steve Atkins
Date:
Subject: Re: Method to detect certain characters in column?