Re: Constraints or assertions
From: Philipp Post <Post.Philipp_at_googlemail.com>
Date: Wed, 6 May 2009 02:08:46 -0700 (PDT)
Message-ID: <489993b8-5c30-4b84-8ff9-b186a6ac9575_at_f1g2000prb.googlegroups.com>
Date: Wed, 6 May 2009 02:08:46 -0700 (PDT)
Message-ID: <489993b8-5c30-4b84-8ff9-b186a6ac9575_at_f1g2000prb.googlegroups.com>
> 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.
brgds
Philipp Post Received on Wed May 06 2009 - 11:08:46 CEST