"Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)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.