MIME-Version: 1.0
In-Reply-To: <cc6b3344a526cafcffa6b8abd653712d8e68ca2e.camel@cybertec.at>
References: <9c84776d-d938-9fa4-ab1-6ee960ce6e7d@appl-ecosys.com>
 <CAKFQuwZ2vqO68y6A64R0VYpsw=uhh1ZaVd-bxeswHRsw2YTnkg@mail.gmail.com>
 <9c62a6d5-14a-802-b869-6386d7e050fb@appl-ecosys.com> <cc6b3344a526cafcffa6b8abd653712d8e68ca2e.camel@cybertec.at>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 14 Jul 2025 22:55:33 -0700
Message-ID: <CAKFQuwbBVOCY4kw23R6Q1cCFs0KwTPcGUrBdcWmf62Srnk4=0A@mail.gmail.com>
Subject: Re: Syntax error needs explanation [RESOLVED]
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Rich Shepard <rshepard@appl-ecosys.com>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000bd9b1d0639f16c7c"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbBVOCY4kw23R6Q1cCFs0KwTPcGUrBdcWmf62Srnk4%3D0A%40mail.gmail.com>
Precedence: bulk

--000000000000bd9b1d0639f16c7c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 y=
ou
> > > 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=E2=80=99s more that an exists subquery with an aggregate generally=
 doesn=E2=80=99t
make sense (it would need to include a having clause at minimum)=E2=80=A6it=
=E2=80=99s not
missing a group by clause, it has aggregates it doesn=E2=80=99t need (they =
belong
in they belong in the main query where the group clause exists without
aggregates to justify its existence.

David J.

--000000000000bd9b1d0639f16c7c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Monday, July 14, 2025, Laurenz Albe &lt;<a href=3D"mailto:laurenz.albe@c=
ybertec.at">laurenz.albe@cybertec.at</a>&gt; wrote:<br><blockquote class=3D=
"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding=
-left:1ex">On Mon, 2025-07-14 at 12:19 -0700, Rich Shepard wrote:<br>
&gt; On Mon, 14 Jul 2025, David G. Johnston wrote:<br>
&gt; <br>
&gt; &gt; The error indicates your script file is at least 127 lines long a=
nd you<br>
&gt; &gt; are showing like 9...also do you usually name your script files w=
ith a<br>
&gt; &gt; .txt extension?<br>
&gt; <br>
&gt; Agh! No the filename extension is .sql. But I was using the \o psql op=
tion<br>
&gt; to write script output to files and mistyped the script name.<br>
&gt; <br>
&gt; Mea culpa!<br>
<br>
Apart from that, the subquery seems to be missing a GROUP BY clause.<br>
</blockquote><div><br></div><div>Well, it=E2=80=99s more that an exists sub=
query with an aggregate generally doesn=E2=80=99t make sense (it would need=
 to include a having clause at minimum)=E2=80=A6it=E2=80=99s not missing a =
group by clause, it has aggregates it doesn=E2=80=99t need (they belong in =
they belong in the main query where the group clause exists without aggrega=
tes to justify its existence.</div><div><br></div><div>David J.</div><div><=
br></div>

--000000000000bd9b1d0639f16c7c--