Re: regexp problem

Yup, that did it.  And you're right, you don't need to escape the '.'.

So the extra \ is needed because of the single quotes string.   Arrrrgggg.....  :-)

Thanks Steve !

On 02/24/2011 10:25 AM, Gauthier, Dave wrote:

select 'abc.def[0]' ~ E'^[a-zA-Z0-9_\.\[\]]+$';

Try:
E'^[a-zA-Z0-9._\\[\\]]+$'

The "outer" level of parsing turns that into '^[a-zA-Z0-9._\[\]]+$' which is the regex you want. Also, I'm *pretty sure* you don't need to escape the '.' within a character class.

Cheers,
Steve