Regex Character-Class

From: Henry <henry(at)zen(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: Regex Character-Class
Date: 2009-06-30 07:09:41
Message-ID: 20090630090941.68486z5rg48d8288@zenmail.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2009-06-30 07:17:25 Re: Unexpected behaviour of date_part
Previous Message Mirko Sertic 2009-06-30 06:07:25 Re: Database schema dumper