Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?

From: Frank Streitzig <fstreitzig(at)gmx(dot)net>
To: kimaidou <kimaidou(at)gmail(dot)com>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?
Date: 2022-05-23 20:39:19
Message-ID: Yovw9wcx8n6WqP8v@frastr-dev
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Hui Jackson 2022-05-25 11:12:49 Using Transaction with if-else in prepared statement
Previous Message kimaidou 2022-05-23 14:33:16 Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?