MIME-Version: 1.0
References: <9c84776d-d938-9fa4-ab1-6ee960ce6e7d@appl-ecosys.com>
In-Reply-To: <9c84776d-d938-9fa4-ab1-6ee960ce6e7d@appl-ecosys.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 14 Jul 2025 12:14:47 -0700
Message-ID: <CAKFQuwZ2vqO68y6A64R0VYpsw=uhh1ZaVd-bxeswHRsw2YTnkg@mail.gmail.com>
Subject: Re: Syntax error needs explanation
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000047724c0639e87b47"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZ2vqO68y6A64R0VYpsw%3Duhh1ZaVd-bxeswHRsw2YTnkg%40mail.gmail.com>
Precedence: bulk

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

On Mon, Jul 14, 2025 at 12:12=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys=
.com>
wrote:

> I have the following script:
>
> select c.company_nbr, c.company_name, i.industry,
> from companies as c, industry as i, enforcement as e
> where exists (
>    select c.company_nbr, count(e.action_date), sum(e.penalty_amt)
>    from e.enforcement
>    where c.company_nbr =3D e.company_nbr
>    )
> group by industry
> order by industry;
>
> When I run it psql reports an error:
> psql:companies-with-enforcement-actions.txt:127: ERROR:  syntax error at
> or near "company_nbr"
> LINE 1: company_nbr |               company_name
>          ^
> and I'm not seeing the error. What am I missing?
>

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?

David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Mon, Jul 14, 2025 at 12:12=E2=80=AFPM Rich Shepard &lt;=
<a href=3D"mailto:rshepard@appl-ecosys.com">rshepard@appl-ecosys.com</a>&gt=
; wrote:</span></div></div><div class=3D"gmail_quote gmail_quote_container"=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex">I have the following scr=
ipt:<br>
<br>
select c.company_nbr, c.company_name, i.industry, <br>
from companies as c, industry as i, enforcement as e<br>
where exists (<br>
=C2=A0 =C2=A0select c.company_nbr, count(e.action_date), sum(e.penalty_amt)=
<br>
=C2=A0 =C2=A0from e.enforcement<br>
=C2=A0 =C2=A0where c.company_nbr =3D e.company_nbr<br>
=C2=A0 =C2=A0)<br>
group by industry<br>
order by industry;<br>
<br>
When I run it psql reports an error:<br>
psql:companies-with-enforcement-actions.txt:127: ERROR:=C2=A0 syntax error =
at or near &quot;company_nbr&quot;<br>
LINE 1: company_nbr |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0company_name<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^<br>
and I&#39;m not seeing the error. What am I missing?<br>
</blockquote><div><br></div><div class=3D"gmail_default" style=3D"font-fami=
ly:arial,helvetica,sans-serif">The error indicates your script file is at l=
east 127 lines long and you are showing like 9...also do you usually name y=
our script files with a .txt extension?</div><div class=3D"gmail_default" s=
tyle=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gma=
il_default" style=3D"font-family:arial,helvetica,sans-serif">David J.</div>=
<div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-seri=
f"><br></div></div></div>

--00000000000047724c0639e87b47--