PostgreSQL 9.3 Lateral Part2: The Lateral Left Join This is an off-site link.  Please review our Terms of Service for additional information.

(Leo Hsu and Regina Obe) In the last article we said you can't have a LEFT JOIN with LATERAL. Turns out we were mistaken and YES indeed you can and when you do it is equivalent or more powerful than SQL Server's OUTER APPLY.

Read this article...

comments powered by Disqus