News for hackers. Stuff that matters.
Re:Postgres Hidden Gems by garyclarke27 on Thursday February 01, 2018 @07:45AM (#16281455)
I agree Lateral Joins are amazing, Ive started using them instead of CTEs a lot recently. Set returning functions are automatically lateral joined and make the logic much easier to follow than sub queries. Performance is great because Postgres happily inlines most SQL functions - unlike my experience with SQL Server (several years ago may have changed) where UDFs where munch slower than sub queries.

There are no comments on this comment yet.