On Fri, 10 Feb 2006 ohp@pyrenet.fr wrote: > My understanding is that null or not, their should have been a foreign key > violation.
Not as far as I can tell. MATCH (without partial or full) returns true if any column in the row value constructor is NULL. MATCH FULL returns true if all columns in the row value constructor are NULL and returns false if it's a mix of NULLs and non-NULLs. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
