not null across multiple columns - Mailing list pgsql-general

From Matthew Terenzio
Subject not null across multiple columns
Date
Msg-id afe02ecbf4cba22a174b9d30a1c4d2aa@jobsforge.com
Whole thread Raw
Responses Re: not null across multiple columns  ("George Pavlov" <gpavlov@mynewplace.com>)
Re: not null across multiple columns  (Reece Hart <reece@harts.net>)
List pgsql-general
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 method to accomplish this sort of constraint?


pgsql-general by date:

Previous
From: "Mike G"
Date:
Subject: Cannot rename file pg_xlog\0000.....
Next
From: "George Pavlov"
Date:
Subject: Re: not null across multiple columns