Re: Fwd: [GENERAL] partial on-delete set null constraint

2015-01-26 Thread Kevin Grittner
Alban Hertroys haram...@gmail.com wrote: Unfortunately, I do not own a copy so I can't verify. If anyone who does own a copy could confirm or even quote the relevant section, that would be great. I have a copy of The RELATIONAL MODEL for DATABASE MANAGEMENT, VERSION 2 (RM/V2), by E. F. Codd,

Fwd: [GENERAL] partial on-delete set null constraint

2015-01-25 Thread Alban Hertroys
The theory got me intrigued. google (http://en.wikipedia.org/wiki/Codd%27s_12_rules) says: rule 3: systematic treatment of null values; hmmm this is a little broader then support for null. I would think, that: 1. if a sequence of update XX set fk_field=null; then delete YY depending

Re: Fwd: [GENERAL] partial on-delete set null constraint

2015-01-25 Thread rob stone
On Sun, 2015-01-25 at 14:09 +0100, Alban Hertroys wrote: The theory got me intrigued. google (http://en.wikipedia.org/wiki/Codd%27s_12_rules) says: rule 3: systematic treatment of null values; hmmm this is a little broader then support for null. I would think, that: 1. if a