how could a foreign key ever be NULL? - Mailing list pgsql-sql

From Terrence Brannon
Subject how could a foreign key ever be NULL?
Date
Msg-id 8BBB36A0-F2E2-11D5-92F7-003065C2A10C@mac.com
Whole thread Raw
In response to Indices  (sharmad@goatelecom.com)
Responses Re: how could a foreign key ever be NULL?
Re: how could a foreign key ever be NULL?
Re: how could a foreign key ever be NULL?
List pgsql-sql
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?



pgsql-sql by date:

Previous
From: Terrence Brannon
Date:
Subject: Re: Numbering Rows (SEQUENCE, OID) questions
Next
From: Bruce Momjian
Date:
Subject: Re: how could a foreign key ever be NULL?