> We have tried dropping the constrainst and re-creating casting the
> check to timestamp rather than date but no change.
What is your constraint_exclusion setting?
If it's not enabled, try enabling it temporarily with "SET constraint_exclusion = on" and re-run your query.
rls
--
:wq
