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