Re: [GENERAL] FOREIGN KEY syntax

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.

Could be wrong, will lookup at Thursday when back in
Hamburg.

Jan from Philly

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026