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