Re: Error in Documentation? (Subqueries in CHECK Constraints / SQL92-Assertions)

Timmy Turner, 23.02.2013 21:56:
> That would add HSQLDB to the list of currently only 2 SQL-based
> DBMSes that somewhat support this (one being MS Access/JET(1) and the
> other MS SQLServer(2)).
>
> (1) http://support.microsoft.com/kb/201888/en-us
>
> (2)
> http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/06/25/scalar-udfs-wrapped-in-check-constraints-are-very-slow-and-may-fail-for-multirow-updates.aspx
>
> Found those links on http://stackoverflow.com/questions/6368349/why-dont-dbmss-support-assertion
>

If you are willing to "hide" the check behind a stored function, then the list is a bit longer than just MS Access and SQL Server.
At least in Postgres and Oracle you can do the same thing.

Thomas


------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb