I am about to create a new table that will store among other things two
dimensions. The user requires that the smaller of the two dimesions always be
referred to as the width.
As I see it I can either implement a CHECK constraint and handle the error or
implement a BEFORE INSERT OR UPDATE trigger that checks the two values and
switches them if necessary.
If I implement the trigger is there any point in implementing the CHECK?
In this simple situation is there any reason to implement the CHECK and not
use a trigger?
Your comments will be appreciated.
pgsql-novice by date
|Next:||From: Keith Worthington||Date: 2005-04-22 20:20:51|
|Subject: char or int vs varchar|
|Previous:||From: Van Ingen, Lane||Date: 2005-04-22 16:59:55|
|Subject: Re: CHECK Constraints|