Ron Peterson <ron.peterson@xxxxxxxxxxxxxx> 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
