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();
On Sun, Jun 14, 2009 at 1:15 AM, Pavel Stehulepavel.steh...@gmail.com wrote:
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' ~
On Sun, Jun 14, 2009 at 08:15:55AM +0200, Pavel Stehule wrote:
postgres=# select '10' ~ '[0..9]+$';
?column?
--
t
(1 row)
regexp '[0..9]+$' tests is given strings containst at the end substring
containing only characters 0, 9 and ..
and yes, it does - the last character is 0, so it
2009/6/14 hubert depesz lubaczewski dep...@depesz.com:
On Sun, Jun 14, 2009 at 08:15:55AM +0200, Pavel Stehule wrote:
postgres=# select '10' ~ '[0..9]+$';
?column?
--
t
(1 row)
regexp '[0..9]+$' tests is given strings containst at the end substring
containing only characters 0,