Postgres Pro
Downloads
Home   >   mailing lists

Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ? - Mailing list pgsql-sql

From Frank Streitzig
Subject Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?
Date
Msg-id Yovw9wcx8n6WqP8v@frastr-dev
Whole thread Raw
In response to Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?  (kimaidou <kimaidou@gmail.com>)
List pgsql-sql
Tree view 
Am Mon, May 23, 2022 at 04:33:16PM +0200 schrieb kimaidou:
> Here is the 4th SQL fiddle with your proposal organized with "WITH" clauses
> http://sqlfiddle.com/#!17/fe902/31/0

yes, you can do it like this.

Regards
Frank

pgsql-sql by date:

Previous
From: kimaidou
Date:
Subject: Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?
Next
From: Hui Jackson
Date:
Subject: Using Transaction with if-else in prepared statement