Hi... I'm dealing with a regular expression in a check constraint for
many days.... i'm stuck with this...
what I'm doing is adding a check to an existing table on a field called
codigoex1 (varchar(9) )
check (codigoex1 ~* '[a-z]{2,2}')
and I can't get it to work!
I want to validate only input data such as "ar" "Us" "bR" and NOT
something like "rum" "a"
the previous reg. expr. only works like it were ~* '[a-z]{2}' , so, it
ignores the maximum length.
Tanks a lot!