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

From Jian He
Subject Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions
Date
Msg-id CAMV54g2OxGKMyuUVwNM0LdDZsvM7XJVbe4WmVRMLNTZ5X1d0Gg@mail.gmail.com
Whole thread Raw
Responses Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql

If the question is stupid, please tell me why. 

postgresql - How to query check the constraint is valid or not - Stack Overflow
Postgres 14 | db<>fiddle (dbfiddle.uk)

CREATE TABLE emp (test_check int check ( test_check >1 and test_check < 0 ));

alter table emp  VALIDATE CONSTRAINT emp_test_check_check;```

select * from pg_constraint where conname = 'emp_test_check_check';

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


another similar question:
can postgresql deduce from
CREATE TABLE emp1 (test_check int check ( test_check >1 and test_check > 10 ));

to

CREATE TABLE emp1 (test_check int check ( test_check > 10 ));

pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: Histogram question.
Next
From: Tom Lane
Date:
Subject: Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions