PFC <lists(at)boutiquenumerique(dot)com> writes:
> Here you don't need to LEFT JOIN, you can use a straight simple
> unconstrained join because the rows generated by the LEFT JOINs which have
> NULL in the right columns will be rejected by the WHERE clause anyway :
In recent versions of Postgres, the planner knows this and can make the
simplification for itself, at least if the operator or function used in
WHERE is properly marked as strict.
regards, tom lane