Ron Peterson <ron(dot)peterson(at)yellowbank(dot)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