PostgreSQL's Powerful New Join Type: Lateral | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

		PostgreSQL's Powerful New Join Type: Lateral (heapanalytics.com)
		2 points by craigkerstiens on Jan 31, 2018 \| hide \| past \| favorite \| 1 comment

ak39 on Jan 31, 2018 [–]

T-SQL has this as CROSS APPLY and OUTER APPLY.

Like pgsql’s LATERAL JOIN, CROSS APPLY has been a game changer in the way you think iteration in sets. Highly recommended.

Consider applying for YC's Summer 2025 batch! Applications are open till May 13
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact