Constraint

From: "Joo" Paulo Batistella <batistellabr(at)yahoo(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Constraint
Date: 2002-07-16 15:29:54
Message-ID: 20020716152954.22136.qmail@web21204.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rick Eicher II 2002-07-16 15:34:46 Re: Backend died abnormally - postgresql 7.2.1-5
Previous Message Bruno Wolff III 2002-07-16 15:07:33 Re: Securing PostgreSQL