Postgres Pro
Downloads
Home   >   mailing lists

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

From Ian Meyer
Subject Re: Method to detect certain characters in column?
Date
Msg-id b54105080806231648o542efd1ahb6b3d17977cfdbd9@mail.gmail.com
Whole thread Raw
In response to Re: Method to detect certain characters in column?  (Steve Atkins <steve@blighty.com>)
Responses Re: Method to detect certain characters in column?
List pgsql-general
Tree view 
Ah, so I forgot to mention the one caveat to this (sorry!) was there
was a ton of punctuation/spaces and other ilk.. so this is what I came
up with:

bco=# select name from member where not (name ~ '^[A-Za-z0-9[:punct:] ]*$');
         name
----------------------
 Señorita Lolita
 Long Pig
 täkäurgh
 blåbärsöl
 fuchér MkII
 fuchér ver2.0
 Gûm-ishi Ashi Gurum
 kängnäve
 Fuchér-version 2.1
 fuchÃ(c)r


Thank you everyone for your help.. that looks to be the correct amount
I was looking for.

Ian
On Mon, Jun 23, 2008 at 7:28 PM, Steve Atkins <steve@blighty.com> wrote:
>
> On Jun 23, 2008, at 1:58 PM, Ian Meyer wrote:
>
>> 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?
>
> ... WHERE column ~* '[^a-z0-9]'
>
> Cheers,
>  Steve
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Update Join Query
Next
From: "Michael Shulman"
Date:
Subject: tables referenced from insert...returning