Re: [GENERAL] FOREIGN KEY syntax

2000-03-07 Thread Oliver Elphick
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 m

Re: [GENERAL] FOREIGN KEY syntax

2000-03-06 Thread Bruce Momjian
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 PART

Re: [GENERAL] FOREIGN KEY syntax

2000-03-03 Thread Oliver Elphick
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, th