
> 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

yes

> 
>   select * from test where a > 0;
> 
> doesn't return any null values.

yes

> 
> Is this the intended behaviour?

Yes, previous behavior was wrong.

Andreas

Wed, 13 Sep 2000 10:53:20 +0200
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: null in constraints