Kind people, I have a little puzzlement. In the first select, I double the backslash and return true. In the second, I don't and get false. Have I missed something important in the docs?
Cheers, D test=> select version(); version ------------------------------------------------------------------------------------------------------- PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5) (1 row) test=> select ('123' ~ '\\d'); ?column? ---------- t (1 row) test=> select ('123' ~ '\d'); ?column? ---------- f (1 row) -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 cell: +1 415 235 3778 Not believing in force is the same as not believing in gravitation Leon Trotsky ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings