Re: Constraints or assertions

From: Philipp Post <>
Date: Wed, 6 May 2009 02:08:46 -0700 (PDT)
Message-ID: <>

> I have posted a few ideas on implementing business rules in the database: <

I would appreciate CREATE ASSERTION statements too. This would be a more genric tool than putting this into a FOREIGN KEY constraint. Not all the rules you might want to enforce involve a foreign key. Also this would be according to the SQL standard.

To allow subqueries (also from diff. tables) in CHECK constraints would also be interesting.


Philipp Post Received on Wed May 06 2009 - 11:08:46 CEST

Original text of this message