the 8.0 manual says CHECK can be used in the following manner:
The only stipulations are that it must produce a boolean result (true or unknown) to succeed.
If I were to specify a the following on a field named price in one expression, would it succeed?
CHECK (price = 1 OR price = 2 OR price = 3)
In other words, I would want to raise an exception on any other value other than 1, 2, or 3. Can
this be done? All of the examples in the manual show a single check (like price > 0) .
pgsql-novice by date
|Next:||From: Walker, Jed S||Date: 2005-04-22 16:11:00|
|Subject: Re: Authorized privileges when calling a procedure |
|Previous:||From: Bruno Wolff III||Date: 2005-04-22 15:14:18|
|Subject: Re: Granting permission on a sequence to a group|