Date: Mon, 14 Jul 2025 13:13:17 -0700 (PDT)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Syntax error needs explanation [RESOLVED]
In-Reply-To: <CAKFQuwZWnGB2weH87+z4zn8mTg83rso2Cy4P2=fqqcAM9p5iWg@mail.gmail.com>
Message-ID: <f831272d-ac28-489-cdbe-356c78bb87d5@appl-ecosys.com>
References: <9c84776d-d938-9fa4-ab1-6ee960ce6e7d@appl-ecosys.com> <7ec33517-6dc1-4e1d-b741-0c26eba7cc79@aklaver.com> <bb74e92e-1cf-1f7e-eeaa-44ce4162f7fd@appl-ecosys.com> <ce828b41-3e25-4f68-aed2-397fddff8849@aklaver.com> <6684eaa7-e6e2-a45b-cff9-44597ca3c8ad@appl-ecosys.com>
 <CAKFQuwZWnGB2weH87+z4zn8mTg83rso2Cy4P2=fqqcAM9p5iWg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
Archived-At: <https://www.postgresql.org/message-id/f831272d-ac28-489-cdbe-356c78bb87d5%40appl-ecosys.com>
Precedence: bulk

On Mon, 14 Jul 2025, David G. Johnston wrote:

> Yeah, you need both to read up on aggregate queries and correlated
> subqueries which is typically how one makes uses of exists (it's called a
> semi-join in this formulation)

David,

Thanks. I wasn't sure what to read.

> Not tested, but:
>
> select c.industry, count(*)
> from companies as c
> where exists (
> select from enforcement as e
> where e.company_nbr = c.company_nbr
> )
> group by c.industry;

Works as intended.

Many thanks,

Rich