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 !
From: Steve Crawford [mailto:scrawford@xxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, February 24, 2011 1:40 PM
To: Gauthier, Dave
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: regexp problem
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
