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 s

Re: [GENERAL] not null across multiple columns

2006-11-02 Thread George Pavlov
[mailto:[EMAIL PROTECTED] 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 o

[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 best