> 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
