here is an interesting question (to me)
suppose you wanted to be certain that either one of two or more columns
were present
Like in a user table, either a username or an email need to be present
to create a row.
You can't use not null because it's an either or situation.
what's the
] On Behalf Of
Matthew Terenzio
Sent: Thursday, November 02, 2006 4:11 PM
To: PostgreSQL general
Subject: [GENERAL] not null across multiple columns
here is an interesting question (to me)
suppose you wanted to be certain that either one of two or
more columns were present
Like
On Thu, 2006-11-02 at 19:10 -0500, Matthew Terenzio wrote:
suppose you wanted to be certain that either one of two or more
columns were present
Like in a user table, either a username or an email need to be present
to create a row.
You can't use not null because it's an either or