public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: Rich Shepard <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Syntax error needs explanation [RESOLVED]
Date: Mon, 14 Jul 2025 22:55:33 -0700
Message-ID: <CAKFQuwbBVOCY4kw23R6Q1cCFs0KwTPcGUrBdcWmf62Srnk4=0A@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<CAKFQuwZ2vqO68y6A64R0VYpsw=uhh1ZaVd-bxeswHRsw2YTnkg@mail.gmail.com>
	<[email protected]>
	<[email protected]>

On Monday, July 14, 2025, Laurenz Albe <[email protected]> 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.

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Syntax error needs explanation [RESOLVED]
  In-Reply-To: <CAKFQuwbBVOCY4kw23R6Q1cCFs0KwTPcGUrBdcWmf62Srnk4=0A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox