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

On Tue, Sep 28, 2004 at 03:02:02PM +0100, T E Schmitz wrote:
> Hello,
>
> Is it possible to set up a table CHECK, which ensures that column A is
> NOT NULL if column B = 'x' ?

Sure.

fduch(at)~=# CREATE TABLE test (
fduch(at)~(# a integer check (case when b = 'x' then a is not null else true end),
fduch(at)~(# b text);
CREATE TABLE
fduch(at)~=# INSERT INTO test VALUES (null, '123');
INSERT 107538 1
fduch(at)~=# INSERT INTO test VALUES (null, 'x');
ERROR: new row for relation "test" violates check constraint "test_a"
fduch(at)~=# INSERT INTO test VALUES (1, 'x');
INSERT 107539 1

--
Fduch M. Pravking