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:scrawf...@pinpointresearch.com] Sent: Thursday, February 24, 2011 1:40 PM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] 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
