Hello can somebody explain this behave?
postgres=# select '10' ~ e'^\\d+$'; ?column? ---------- t (1 row) ok postgres=# select '10' ~ '[0..9]+$'; ?column? ---------- t (1 row) ok postgres=# select '10' ~ '^[0..9]+$'; ?column? ---------- f (1 row) ????? postgres=# select version(); version --------------------------------------------------------------------------------------------------- PostgreSQL 8.3.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.4.0 20090506 (Red Hat 4.4.0-4) (1 row) tested on fedora 11 Regards Pavel Stehule -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers