Alright, the first two attempts to reply to this thread I don't believe worked, likely due to the attachment size. Hoping this time it does...
> > Self contained examples do wonders > Good point, will work on that and post once I have something usable.
Finally got around to making a self contained example... busy few months.
Attached is a pg_dump file which will create a schema called test, and load up some real-world data for the specified tables. Extract it, then load. > psql -f excl_test.sql
Then you can run the following which should hit the condition outlined above:
SELECT * FROM test.claim INNER JOIN test.claim_amounts ON claim.claim_id = claim_amounts.claim_id LEFT JOIN test.deduction_claim ON deduction_claim.claim_id = claim.claim_id AND upper_inf(deduction_claim.active_range) WHERE claim.claim_id = ANY (