[HACKERS] postgresql regular expr bug?

2009-06-14 Thread Pavel Stehule
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();

Re: [HACKERS] postgresql regular expr bug?

2009-06-14 Thread Stephen J. Butler
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' ~

Re: [HACKERS] postgresql regular expr bug?

2009-06-14 Thread hubert depesz lubaczewski
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

Re: [HACKERS] postgresql regular expr bug?

2009-06-14 Thread Pavel Stehule
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,