NULL Foreign Key

From: "Kuhn, Dylan K (NDTI)" <KuhnDK(at)navair(dot)navy(dot)mil>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: NULL Foreign Key
Date: 2002-07-17 00:10:32
Message-ID: E706EFF2C59F0541A2BC43B99E1ED15322ED32@nwms14.chinalake.navy.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

I'm about to conclude that I can't do this, but I thought I'd ask first:

Can I make a foreign key that is allowed to be NULL? I have several
situations where I want a field to reference another table, but not be
required.

thanks,

Dylan Kuhn
New Directions Technologies, Inc.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2002-07-17 00:33:06 Re: PostgreSQL in mission-critical system
Previous Message Neil Conway 2002-07-16 23:43:07 Re: table size growing out of control