Skip site navigation (1) Skip section navigation (2)

Re: regexp problem

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: regexp problem
Date: 2011-02-24 20:12:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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
Cc: pgsql-general(at)postgresql(dot)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_\.\[\]]+$';


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 IgrishinDate: 2011-02-24 21:08:52
Subject: Re: array size
Previous:From: John R PierceDate: 2011-02-24 19:46:48
Subject: Re: database is bigger after dump/restore - why? (60 GB to 109 GB)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group