Get the latest tech news

Postgres's lateral joins allow for quite the good eDSL


you can build a query eDSL with them. Postgres (and a few other databases(?)) has a lesser known or used join type known as the lateral join.

None

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Postgres

Postgres

Photo of lateral joins

lateral joins

Photo of good eDSL

good eDSL

Related news:

News photo

Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQLite

News photo

MOS tech 6502 8-bit microprocessor in pure SQL powered by Postgres

News photo

Show HN: Postgres extension for BM25 relevance-ranked full-text search