Re: list non alphanumeric

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: list non alphanumeric
Date: 2013-04-12 07:12:04
Message-ID: 5167B3C4.6060805@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/11/2013 11:50 PM, Baboo, Isa wrote:
>
> Thanks for the response but I tried that and it does not work here is
> an example of names which still display.
>
> test
>
> sadadds
>
> Hillary
>
> BEN NAME
>
> ALAN MCGARVEY +
>

well, at least one of those has a space inline, you didn't say that was
acceptable, just a-z0-9
and of course, upper and lower case, so you probably should use
[A-Za-z0-9 ] (note the space before the close bracket)

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Baboo, Isa 2013-04-12 07:16:38 Re: list non alphanumeric
Previous Message Ian Lawrence Barwick 2013-04-12 07:07:36 Re: list non alphanumeric