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 -- ---> Dirk Jagdmann ----> http://cubic.org/~doj -----> http://llg.cubic.org -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
