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