Quick Links

CHECK col A not NULL if col B='x'

From:	T E Schmitz <mailreg(at)numerixtechnology(dot)de>
To:	pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject:	CHECK col A not NULL if col B='x'
Date:	2004-09-28 14:02:02
Message-ID:	41596EDA.4030909@numerixtechnology.de
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

Hello,

Is it possible to set up a table CHECK, which ensures that column A is
NOT NULL if column B = 'x' ?

--

Regards/Gruß,

Tarlika Elisabeth Schmitz

Responses

Re: CHECK col A not NULL if col B='x' at 2004-09-28 14:12:02 from Martin Marques
Re: CHECK col A not NULL if col B='x' at 2004-09-28 14:15:04 from Alexander M. Pravking

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Tom Lane	2004-09-28 14:05:14	Re: FOREIGN KEY and AccessExclusiveLock
Previous Message	Achilleus Mantzios	2004-09-28 13:34:43	Re: FOREIGN KEY and AccessExclusiveLock