From: Lars Gustafsson <gumse@mac.com>
To: pgsql-sql@postgresql.org
Subject: Re: please help me on regular expression
Date: Wed, 3 Feb 2010 22:33:43 +0100
Message-ID: <C40F84E4-6202-4A67-A1FA-D412D3D09F7F@mac.com> (raw)
In-Reply-To: <C78F1F2A.921D%tsakai@gallo.ucsf.edu>
References: <C78F1F2A.921D%tsakai@gallo.ucsf.edu>
Some people, when confronted with a problem, think "I know, I'll use
regular expressions." Now they have two problems. — Jamie Zawinski
3 feb 2010 kl. 21.32 skrev Tena Sakai:
> Thank you, Dirk.
>
> Regards,
>
> Tena Sakai
> tsakai@gallo.ucsf.edu
>
>
> On 2/3/10 11:43 AM, "Dirk Jagdmann" <jagdmann@gmail.com> wrote:
>
>> Be careful when working with backslashes and regular expressions for
>> the proper (double) escaping!
>>
>> # select '70a5' ~ e'\\d+\.\\d+';
>> ?column?
>> ----------
>> t
>> (1 row)
>>
>> # select '70a5' ~ e'\\d+\\.\\d+';
>> ?column?
>> ----------
>> f
>> (1 row)
>>
>> # select '70.5' ~ e'\\d+\\.\\d+';
>> ?column?
>> ----------
>> t
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gumse@mac.com
Subject: Re: please help me on regular expression
In-Reply-To: <C40F84E4-6202-4A67-A1FA-D412D3D09F7F@mac.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox