Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions

Jian He <hejian.mark@gmail.com> writes:
> CREATE TABLE emp (test_check int check ( test_check >1 and test_check
> < 0 ));

> Even with the above mentioned step, does postgresql know above check
> constraint condition always false.

No, not explicitly.  If the constraint always fails, that is
your problem not Postgres'.

            regards, tom lane