Re: [GENERAL] Regex Character-Class

Quoting "A. Kretschmer" : Try: test=*# SELECT '1.1.1.1' ~ E'^\\d+'; Ag, of course, thanks Andreas. Cheers Henry pgp5XMelkfQ4Y.pgp Description: PGP Digital Signature

Re: [GENERAL] Regex Character-Class

Henry schrieb: 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? Yes; you have to escape the backslash character:

Re: [GENERAL] Regex Character-Class

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: 03

[GENERAL] Regex Character-Class

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 pgptxHPEfsSfe.pgp Description: PGP Digit