two not null columns - Mailing list pgsql-general

From Garry Saddington
Subject two not null columns
Date
Msg-id 200804141732.53343.garry@schoolteachers.co.uk
Whole thread Raw
Responses Re: two not null columns
List pgsql-general
How would I write a table check constraint to make sure that two columns don't
both have nulls at the same time.
The following doesn't do it because it because it does not allow one column to
be null while the other holds data?

check(teachgroup is not null AND set is not null)

regards
garry

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: The default text search configuration will be set to "simple" ?
Next
From: Andreas Kretschmer
Date:
Subject: Re: two not null columns