Re: how is that possible

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.