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.Elphick@lfix.co.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