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(at)pinpointresearch(dot)com]
Sent: Thursday, February 24, 2011 1:40 PM
To: Gauthier, Dave
Subject: Re: [GENERAL] regexp problem
On 02/24/2011 10:25 AM, Gauthier, Dave wrote:
select 'abc.def' ~ 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.
In response to
pgsql-general by date
|Next:||From: Dmitriy Igrishin||Date: 2011-02-24 21:08:52|
|Subject: Re: array size|
|Previous:||From: John R Pierce||Date: 2011-02-24 19:46:48|
|Subject: Re: database is bigger after dump/restore - why? (60 GB
to 109 GB)|