Postgres Pro
Downloads
Home   >   mailing lists

Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions - Mailing list pgsql-sql

From Tom Lane
Subject Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions
Date
Msg-id 2977557.1649218225@sss.pgh.pa.us
Whole thread Raw
In response to Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions  (Jian He <hejian.mark@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Jian He
Date:
Subject: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions
Next
From: "David G. Johnston"
Date:
Subject: Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions