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!
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
