Matias Surdi <[EMAIL PROTECTED]> writes:
> 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"
Use something like '^[a-z]{2}$'
Regards,
Manuel.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
