Re: [GENERAL] FOREIGN KEY syntax

Andrzej Mazurkiewicz wrote:
>> And what is MATCH FULL?
> [Andrzej Mazurkiewicz] I would not like to speculate perhaps
>somebody else knows exact answer.

MATCH FULL:
Either all referencing columns must be null, or all must have values.

MATCH PARTIAL:
"if any columns are non-null, there must be at least one row in the
referenced table that could satisfy the constraint if the other null
values were correctly substituted."
(The SQL Standard Handbook, Cannan & Otten)
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"A new commandment I give to you, that you love one
another, even as I have loved you."
John 13:34