All examples I've seen for check constraints use the column names
without NEW or OLD prepended.
When NEW or OLD is not included, what value is used? Does it
auto-magically resolve to COALESCE(NEW.column,OLD.column)?

Rick DeBay
Senior Software Developer
RxStrategies.net