Laurent Martelli <laurent(dot)martelli(at)enercoop(dot)org> writes:
> Do we agree that both queries are identical ?
No, they *aren't* identical. Go consult any SQL reference. Left join
conditions don't work the way you seem to be thinking: after the join,
the RHS column might be null, rather than equal to the LHS column.
regards, tom lane