Re: enforce null only
On 23 Feb, 22:47, Jonathan Leffler <jleffler.i...@gmail.com> wrote:
>
> CREATE TABLE t
> (
> i SERIAL,
> a CHAR(1) NOT NULL CHECK (a IN ('S', 'T')),
> b CHAR(5),
> CHECK (b IS NULL OR a = 'S')
> );>
> INSERT INTO t(i,a,b) VALUES(0,'T','a');> Error: SQL -530: Check constraint (jleffler.c471_1339) failed.
> INSERT INTO t(i,a,b) VALUES(0, 'S', 'aaa');>
> Works for me - IDS 11.50. Does it work for you?
>
> --
Works for me on 9.30HC5, HP-UX 11i.
NB also works correctly with INSERT INTO t(i,a,b) VALUES(0,'T',NULL);
Malc