Re: [BUGS] BUG #1686: Regular expression problem

2005-05-31 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > On Tue, May 31, 2005 at 11:15:23 -0400, > Alvaro Herrera <[EMAIL PROTECTED]> wrote: >> (Note that our ~ regexes are powered by code of Tcl's heritage, so you >> could check Tcl's manual on regexes.) > Aren't they based directly on Henry Spencer's cod

Re: [BUGS] BUG #1686: Regular expression problem

2005-05-31 Thread Bruno Wolff III
On Tue, May 31, 2005 at 11:15:23 -0400, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > (Note that our ~ regexes are powered by code of Tcl's heritage, so you > could check Tcl's manual on regexes.) Aren't they based directly on Henry Spencer's code? ---(end of broadcast)

Re: [BUGS] BUG #1686: Regular expression problem

2005-05-31 Thread Alvaro Herrera
On Sat, May 28, 2005 at 11:22:12PM +0100, Halley Pacheco de Oliveira wrote: > [third query:] > > SELECT '200.222.197.219' SIMILAR TO '([\\w-]+).([\\w-]+).([\\w]+)'; > > ?column? > -- > f > (1 row) > > Why does the third query gives a different output? It is not exactly the > same as the

[BUGS] BUG #1686: Regular expression problem

2005-05-31 Thread Halley Pacheco de Oliveira
The following bug has been logged online: Bug reference: 1686 Logged by: Halley Pacheco de Oliveira Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 and 8.0 Operating system: Linux and Windows Description:Regular expression problem Details: SELECT '200.222.1