Postgres Pro
Downloads
Home   >   mailing lists

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  (sklassen@commandprompt.com)
Re: database constraints  (David Fetter <david@fetter.org>)
List pgsql-general
Tree view 
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