database constraints - Mailing list pgsql-general

From Ben
Subject database constraints
Date
Msg-id A27C13B0-17AB-11D9-8A0D-000A95BF2A8C@silentmedia.com
Whole thread Raw
Responses Re: database constraints
Re: database constraints
List pgsql-general
If I have have the table:

create table foo
(
    a int references bar(id),
    b int references baz(id)
)

... how do I make sure one and only one of the columns a and b are
non-null? Is it even reasonable?


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cache lookup failed for relation, when trying to DROP TABLE.
Next
From: Michael Fuhr
Date:
Subject: Re: Random not so random