Re: Syntax error needs explanation [RESOLVED]

On Monday, July 14, 2025, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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.