Subject | RE: [Firebird-Architect] Nulls in CHECK Constraints |
---|---|
Author | Claudio Valderrama C. |
Post date | 2005-10-27T03:23:53Z |
> -----Original Message-----The code has existed always to generate checks for DELETE...
> From: Firebird-Architect@yahoogroups.com
> [mailto:Firebird-Architect@yahoogroups.com]On Behalf Of Martijn Tonies
> Sent: MiƩrcoles, 26 de Octubre de 2005 6:38
>
> Might be, but given that our CHECKs are only evaluated on insert/update
> (and not even on DELETE), could make them useless in certain occasions
> when referring to other tables.
but it has been always commented, too. We got it this way from Borland.
Can you explain how a check on delete is necessary? I don't get the idea.
Maybe if it references another table, but a thing like check (a > 0) has
little sense when deleting. It should have been validated at insertion or
update time.
C.