On 2021-05-05 22:58, Pól Ua L. via Firebird-devel wrote:
If I can't even do intra-table (as opposed to inter-table) SQL in the
CHECK constraint, what's the point in allowing SQL in the constraint
at all?
I mean, what does SQL "bring to the party" in this case if I can't use
it in this way?
It works because we allow expressions in a check constraint, which
includes `EXISTS`, etc. And yes, though it can sometimes be useful, in
some situations it is just a good way to shoot yourself in the foot.
Mark
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
