Received: from scaup.prod.itd.earthlink.net (scaup.mail.pas.earthlink.net [207.217.120.49]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBHGd6m74078 for ; Mon, 17 Dec 2001 11:39:09 -0500 (EST) (envelope-from metaperl@mac.com) Received: from pool0421.cvx7-bradley.dialup.earthlink.net ([209.178.165.166] helo=localhost) by scaup.prod.itd.earthlink.net with esmtp (Exim 3.33 #1) id 16G0mm-0001b6-00 for pgsql-sql@postgresql.org; Mon, 17 Dec 2001 08:38:40 -0800 Date: Mon, 17 Dec 2001 03:38:09 -0800 Subject: how could a foreign key ever be NULL? Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v475) From: Terrence Brannon To: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit In-Reply-To: <3c1586d6.6d0.0@punweb01> Message-Id: <8BBB36A0-F2E2-11D5-92F7-003065C2A10C@mac.com> X-Mailer: Apple Mail (2.475) X-Archive-Number: 200112/181 X-Sequence-Number: 6003 The Momjian book states: A single-column foreign key is either NULL or matches a primary key But the problem I have with this statement is that a primary key cannot be null or duplicate. And since the foreign key references a value that is neither null or duplicate, how could it ever be NULL?