Re: please help me on regular expression

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(at)gallo(dot)ucsf(dot)edu
>
>
> On 2/3/10 11:43 AM, "Dirk Jagdmann" <jagdmann(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql