Constraint - Mailing list pgsql-general

From João" Paulo Batistella
Subject Constraint
Date
Msg-id 20020716152954.22136.qmail@web21204.mail.yahoo.com
Whole thread Raw
Responses Re: Constraint
List pgsql-general
Hi.

I would like to make the following constraint in my
db.

I have three fields:
-field1
-field2
-field3

If field1 is not null, then field2 and field3 MUST be
null. Again, if field2 is not null, then field1 and
field3 MUST be null, and so on...

Is it possible?
How can I do that?

Thanks,
JP

__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com

pgsql-general by date:

Previous
From: nconway@klamath.dyndns.org (Neil Conway)
Date:
Subject: Re: Backend died abnormally - postgresql 7.2.1-5
Next
From: "Rick Eicher II"
Date:
Subject: Re: Backend died abnormally - postgresql 7.2.1-5