Re: FInding "corrupt" values in UTF-8 tables (regexp question, I think) - Mailing list pgsql-general

"Phoenix Kiula" <phoenix.kiula@gmail.com> writes:

>
>     select id, t_code
>     from traders
>     where t_code ~ '[^A-Za-z1-9\-\_]'
>     limit 100;
>
> This gives me an error: "ERROR:  invalid regular expression: invalid
> character range".

Put the dash at the start of the character class: [^-A-Za-z1-9_]

>
> What am I missing?

In a character class expression the dash has an special meaning. If
you need to match a dash it has to be the first character.

Regards,
Manuel.