Thank you, Dirk. Regards,
Tena Sakai tsa...@gallo.ucsf.edu On 2/3/10 11:43 AM, "Dirk Jagdmann" <jagdm...@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