lateraljoin   2

PostgreSQL’s Powerful New Join Type: LATERAL
PostgreSQL 9.3 has a new join type! Lateral joins arrived without a lot of fanfare, but they enable some powerful new queries that were previously only tractable with procedural code. In this post, I’ll walk through a conversion funnel analysis that wouldn’t be possible in PostgreSQL 9.2.
postgresql  lateraljoin  sql 
december 2014 by lidel

related tags

analytics  apply  intro  postgresql  sql 

Copy this bookmark: