Postgres Pro
Downloads
Home   >   mailing lists

Re: Regex Character-Class - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Regex Character-Class
Date
Msg-id 20090630072326.GC19653@a-kretschmer.de
Whole thread Raw
In response to Regex Character-Class  (Henry <henry@zen.co.za>)
Responses Re: Regex Character-Class
List pgsql-general
Tree view 
In response to Henry :
> Greets,
>
> I must be missing something here:
>
> SELECT '1.1.1.1' ~ E'^\d+';
>
> returns FALSE, when I would expect TRUE, as for:

Try:

test=*# SELECT '1.1.1.1' ~ E'^\\d+';
 ?column?
----------
 t
(1 row)



Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Unexpected behaviour of date_part
Next
From: Thomas Pundt
Date:
Subject: Re: Regex Character-Class