This post originated from an RSS feed registered with Java Buzz by justin cater. Original Post: Awesome SQL Trick: Constraints on Views Feed Title: Java Code Geeks Feed URL: http://feeds.feedburner.com/JavaCodeGeeks Feed Description: Java 2 Java Developers Resource Center Latest Java Buzz Posts Latest Java Buzz Posts by justin cater Latest Posts From Java Code Geeks

CHECK constraints are already pretty great when you want to sanitize your data. But there are some limitations to CHECK constraints, including the fact that they are applied to the table itself, when sometimes, you want to specify constraints that only apply in certain situations. This can be done with the SQL standard WITH CHECK […]