On Thu, Feb 24, 2011 at 2:12 PM, Gauthier, Dave wrote:
> 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.
> A. :-)
Yes...highly advise dollar quoting whenever dealing with regex.
merlin
--
Sent
M
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 in
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 ch
I want to include '[', ']', and '.' in a list of permitted chars in a regexp.
This doesn's seem to work...
select 'abc.def[0]' ~ E'^[a-zA-Z0-9_\.\[\]]+$';
?collum?
f
(1 row)
Help!
