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

Поиск
Список
Период
Сортировка
От Jian He
Тема Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions
Дата
Msg-id CAMV54g2OxGKMyuUVwNM0LdDZsvM7XJVbe4WmVRMLNTZ5X1d0Gg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions
Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions
Список 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 по дате отправления: