> > > If I ran a select * from A where date1 >= '2009-07-02' and date1 < > > '2009-07-15' then I would think it wouldn't check O. > [Spotts, Christopher] I oversimplified this too much - but I figured out what was happening. If you added the June table as well and added a separate NOT constraint for June, and then wrote the query "SELECT * from A where date1 >= '2009-06-01' and date1 < '2009-07-05'" the planner can't match them to individual constraints, so it doesn't exclude. Theoretically the planner could logically "AND" them together to get better exclusion, but it must not be.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
