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  (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>)
Список 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 по дате отправления:

Предыдущее
От: Steve Midgley
Дата:
Сообщение: Re: Histogram question.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions