On Monday, July 14, 2025, Laurenz Albe <
laurenz.albe@cybertec.at> wrote:
On Mon, 2025-07-14 at 12:19 -0700, Rich Shepard wrote:
> On Mon, 14 Jul 2025, David G. Johnston wrote:
>
> > The error indicates your script file is at least 127 lines long and you
> > are showing like 9...also do you usually name your script files with a
> > .txt extension?
>
> Agh! No the filename extension is .sql. But I was using the \o psql option
> to write script output to files and mistyped the script name.
>
> Mea culpa!
Apart from that, the subquery seems to be missing a GROUP BY clause.
Well, it’s more that an exists subquery with an aggregate generally doesn’t make sense (it would need to include a having clause at minimum)…it’s not missing a group by clause, it has aggregates it doesn’t need (they belong in they belong in the main query where the group clause exists without aggregates to justify its existence.
David J.
