3 ms·
If any one here is doing serious DB based business logic with PostgreSQL (which I do recommend), I'd implore them to investigate and start using LATERAL JOIN.
by ak39 10y ago
If any one here is doing serious DB based business logic with PostgreSQL (which I do recommend), I'd implore them to investigate and start using LATERAL JOIN.
http://blog.heapanalytics.com/postgresqls-powerful-new-join-type-lateral/ http://blog.heapanalytics.com/postgresqls-powerful-new-join-...
This is no doubt a game changer in the way you organize (modularise for reuse) your views, functions and stored procedures.
In the MS SQL world it's CROSS APPLY.
- bhanu423 10y agoGlad I found this blog. I am trying to build analytics engine for offline world and have chosen post-gres as my storage layer. These posts are invaluable and simply awesome. Thanks for sharing!!
- snaky 10y ago> to investigate and start using LATERAL JOIN And modern SQL at all - http://use-the-index-luke.com/blog/2015-02/modern-sql http://use-the-index-luke.com/blog/2015-02/modern-sql