News for hackers. Stuff that matters.
Re:PostgreSQL Exercises by ak39 on Saturday July 02, 2016 @03:51PM (#12023601)
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-...

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.

Re:PostgreSQL Exercises by snaky on Saturday July 02, 2016 @11:30PM (#12024708)
> to investigate and start using LATERAL JOIN

And modern SQL at all - http://use-the-index-luke.com/blog/2015-02/modern-sql

Re:PostgreSQL Exercises by bhanu423 on Saturday July 02, 2016 @07:23PM (#12024161)
Glad 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!!