Archive for september, 2023

PostgreSQL powerful LATERAL join

PostgreSQL supports the SQL join type: LATERAL. Useful for creating advanced query’s. What is a LATERAL join? In the PostgreSQL documentation: Subqueries appearing in FROM can be preceded by the key word LATERAL. This allows them to reference columns provided by preceding FROM items. (Without LATERAL, each subquery is evaluated […]

Read More