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