null in constraints - Mailing list pgsql-hackers

From Andreas Degert
Subject null in constraints
Date
Msg-id 87r96o7kap.fsf@tarzan.noname
Whole thread Raw
Responses Re: null in constraints
List pgsql-hackers
Hello Hackers,

with V7.02, it seems when a constraint evalutes to 'null', it behaves
like 'true'. I'm rather sure this behaviour changed from V6.x, though I 
can't check it.

example:
 create table test (a int4 check (a > 0));

allows a to be null. But
 select * from test where a > 0;

doesn't return any null values.

Is this the intended behaviour?

cheers
Andreas


pgsql-hackers by date:

Previous
From: Andreas Degert
Date:
Subject: like-operator on index-scan
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: null in constraints