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?