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

Reply via email to