I just watched the very interesting video from Rob Farley "Designing for simplification" and I was wondering if the 4 rules given in the video for join removal also hold on PostgreSQL.
If a view is doing joins that don't:
- add any columns
- eliminate rows
- duplicate rows
- introduce nulls
will the joins be ignored for the queries that don't need them. Or is it a SQL Server thing only ?