Search Postgresql Archives

Regex Character-Class

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greets,

I must be missing something here:

SELECT '1.1.1.1' ~ E'^\d+';

returns FALSE, when I would expect TRUE, as for:

SELECT '1.1.1.1'  ~ E'^[[:digit:]]+';

ie, '[[:digit:]]'  !=  '\d'

In config, "regex_flavor = advanced".

Any ideas?

Thanks
Henry

Attachment: pgpkzwe7kRx2j.pgp
Description: PGP Digital Signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux