FW: [GENERAL] FOREIGN KEY syntax

2000-04-12 Thread Andrzej Mazurkiewicz
FYI > -Original Message- > From: Andrzej Mazurkiewicz > Sent: 3 marca 2000 17:05 > To: 'Ron Peterson' > Cc: [EMAIL PROTECTED] > Subject: RE: [GENERAL] FOREIGN KEY syntax > > > > -Original Message- > From: Ron Peterson [SMTP

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