On Mon, Aug 27, 2001 at 02:31:01PM -0400, Neal Lindsay <[EMAIL PROTECTED]> wrote: > If I create a columnA in a tableA that "REFERENCES tableB(columnB)" in > another table, where column B is not null, does that imply a "NOT NULL" on > my columnA? In other words, does it ensure that the value of A is in the > set of values for B, or that the value of A is in the Bs unless A is null? Column A can have NULL values, in which case it passes the references condition. If you do want it to exist in column B, add a NOT NULL constraint to Column A. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
