Message-ID: <cc6b3344a526cafcffa6b8abd653712d8e68ca2e.camel@cybertec.at>
Subject: Re: Syntax error needs explanation [RESOLVED]
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Rich Shepard <rshepard@appl-ecosys.com>, 
	pgsql-general@lists.postgresql.org
Date: Tue, 15 Jul 2025 07:46:43 +0200
In-Reply-To: <9c62a6d5-14a-802-b869-6386d7e050fb@appl-ecosys.com>
References: <9c84776d-d938-9fa4-ab1-6ee960ce6e7d@appl-ecosys.com>
	 <CAKFQuwZ2vqO68y6A64R0VYpsw=uhh1ZaVd-bxeswHRsw2YTnkg@mail.gmail.com>
	 <9c62a6d5-14a-802-b869-6386d7e050fb@appl-ecosys.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/cc6b3344a526cafcffa6b8abd653712d8e68ca2e.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-07-14 at 12:19 -0700, Rich Shepard wrote:
> On Mon, 14 Jul 2025, David G. Johnston wrote:
>=20
> > 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?
>=20
> Agh! No the filename extension is .sql. But I was using the \o psql optio=
n
> to write script output to files and mistyped the script name.
>=20
> Mea culpa!

Apart from that, the subquery seems to be missing a GROUP BY clause.

Yours,
Laurenz Albe