The following bug has been logged on the website:
Bug reference: 13941
Logged by: Sergiy Gavrylenko
Email address: gsv371@ukr.net
PostgreSQL version: 9.5.0
Operating system: Windows Vista
Description:
PostgreSQL 9.5:
1.
ALTER TABLE schedule ADD CONSTRAINT schedule_fact_quant_val CHECK
(fact_quant BETWEEN 0 AND 23.59 AND (fact_quant - trunc(fact_quant)) <
0.6);
result (pg_constraint.consrc): "(((fact_quant >= (0)::numeric) AND
(fact_quant <= 23.59)) AND ((fact_quant - trunc(fact_quant)) < 0.6))"
2.
ALTER TABLE schedule ADD CONSTRAINT schedule_fact_quant_val CHECK
(((fact_quant >= (0)::numeric) AND (fact_quant <= 23.59)) AND ((fact_quant -
trunc(fact_quant)) < 0.6));
result (pg_constraint.consrc): "((fact_quant >= (0)::numeric) AND
(fact_quant <= 23.59) AND ((fact_quant - trunc(fact_quant)) < 0.6))"
----------------------------------
PostgreSQL 9.4 - identical results!