On Sat, May 28, 2005 at 11:22:12PM +0100, Halley Pacheco de Oliveira wrote:
> [third query:]
> SELECT '220.127.116.11' SIMILAR TO '([\\w-]+).([\\w-]+).([\\w]+)';
> (1 row)
> Why does the third query gives a different output? It is not exactly the
> same as the first query?
Hmm, you are aware that SIMILAR TO is defined by the SQL standard, so
the rules are not exactly the same as POSIX regexes, right? I guess the
\w character class (a Perl-ism, I think) is not defined for SIMILAR TO.
(Note that our ~ regexes are powered by code of Tcl's heritage, so you
could check Tcl's manual on regexes.)
Anyway I wonder why you are trying to use regular expressions when you
could be using the INET type; maybe the INET input function if it came
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Limítate a mirar... y algun día veras"
In response to
pgsql-bugs by date
|Next:||From: Stephan Szabo||Date: 2005-05-31 15:31:57|
|Subject: Re: BUG #1688: inheritance and foreign key creation problem|
|Previous:||From: Tom Lane||Date: 2005-05-31 15:13:08|
|Subject: Re: BUG #1687: Regular expression problem (II) |