2 ms·
Check constraints can compare new values against bounds different than the column's type definition. Like maintaining a SMALLINT between 1-100. Or one could eve
by paulryanrogers 5y ago
Check constraints can compare new values against bounds different than the column's type definition. Like maintaining a SMALLINT between 1-100. Or one could even write trigger based checks that ensure integrity among multiple records' values. (Though I don't recommend it unless the constraints are unlikely to change or one has little control over app layer validation.)