Re: [GENERAL] FOREIGN KEY syntax

Bruce Momjian wrote:
>Oliver Elphick wrote:
>
>> 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."
>
> As I read the SQL3 spec draft, it's that if at least one
> of the columns is NULL, no check is done at all.

What I quoted was based on SQL92. Perhaps it has been changed?

> Could be wrong, will lookup at Thursday when back in
> Hamburg.
>
>
>Jan from Philly

Is this really you, Bruce?

--
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
========================================
"Go ye therefore, and teach all nations, baptizing them
in the name of the Father, and of the Son, and of the
Holy Ghost; Teaching them to observe all things
whatsoever I have commanded you; and, lo, I am with
you alway, even unto the end of the world. Amen."
Matthew 28:19,20