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 > [email protected] > > > On 2/3/10 11:43 AM, "Dirk Jagdmann" <[email protected]> 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
