Re: regular expression limit - Mailing list pgsql-general

From Tom Lane
Subject Re: regular expression limit
Date
Msg-id 24102.1167712200@sss.pgh.pa.us
Whole thread Raw
In response to regular expression limit  (Ron Peterson <ron.peterson@yellowbank.com>)
Responses Re: regular expression limit  (Ron Peterson <ron.peterson@yellowbank.com>)
List pgsql-general
Ron Peterson <ron.peterson@yellowbank.com> writes:
> I believe there's been a change in PostgreSQL's regular expression
> handling w/ 8.2.

Compared to what?  A repeat count of 256 has been an error at least
since 7.4, and is documented as such:

: The numbers m and n within a bound are unsigned decimal integers with
: permissible values from 0 to 255 inclusive.

> I'd like the following domain statement to work.  It used to work in
> 8.1.4, but not now.

Sorry, I don't believe 8.1 took it either.  Consider separating your
concerns, eg

    CHECK( length(VALUE) <= 8192 AND VALUE ~ '^[a-f0-9]+$' )

            regards, tom lane

pgsql-general by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: spooky refusal to insert
Next
From: brian
Date:
Subject: Re: spooky refusal to insert