Hi:
I have to constrain the chars used for table columns. For example...
create table foo (col1 text, col2 text, col3 text);
... where
col1 has to be all uppercase, nothing but [A-Z]
col2 has to be all lowercase [a-z] plus [0-9] is also allowed
col3 can be mixed case plus [0-9] and sqr brackets (but nothing else).
I could put a check constraint on each/every table column, but that seems complicated and potentially slow.
I could do this check using the existing insert and update before triggers, but then I'd have to loop through all the columns and decide one by one how to
check them. Again, slow and complicated.
Is there a better way? Whatever I do, I'd have to be able to capture violations to provide informative feedback to the users through the perl script that'll actually be doing the insert/update.
Thanks in Advance !