Postgres Pro
Downloads
Home   >   mailing lists

CHECK col A not NULL if col B='x' - Mailing list pgsql-sql

From T E Schmitz
Subject CHECK col A not NULL if col B='x'
Date
Msg-id 41596EDA.4030909@numerixtechnology.de
Whole thread Raw
Responses Re: CHECK col A not NULL if col B='x'  (Martin Marques <martin@bugs.unl.edu.ar>)
Re: CHECK col A not NULL if col B='x'  ("Alexander M. Pravking" <fduch@antar.bryansk.ru>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: Best way to know if there is a row
Next
From: Tom Lane
Date:
Subject: Re: FOREIGN KEY and AccessExclusiveLock