Re: enforcing alphabetic/numeric content in "char" column - Mailing list pgsql-novice

Rod Kreisler <rod@23net.net> writes:
> Your regex should be '^[0-9]$' (the one you have will allow any string as
> long as there is a numeric character in it somewhere).

Almost: that only allows a single digit.  Probably '^[0-9]+$' is the
correct regex.

            regards, tom lane