[GENERAL] not null across multiple columns

2006-11-02 Thread Matthew Terenzio
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

Re: [GENERAL] not null across multiple columns

2006-11-02 Thread George Pavlov
] 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

Re: [GENERAL] not null across multiple columns

2006-11-02 Thread Reece Hart
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