MIME-Version: 1.0
In-Reply-To: <CA+FnnTyXFh+sXTOC7HMU0eLDmW0YLhWjX+Z89V9uzg5gtFcHLQ@mail.gmail.com>
References: <CA+FnnTyWEsYi=_QTeSXoGXd7Fkd8C7_AnCc5=hho-DZF9_iunQ@mail.gmail.com>
 <90741d5f-5cda-4c4a-84f4-c470129732f4@aklaver.com> <CA+FnnTz9-cjBDf3mC9fx_FCtZGDTneF9=w8LpTRdwCfxHN86yw@mail.gmail.com>
 <CAKFQuwZGjMYbP0nWYb2+-D1a_dNg6b-mDhDC96Am-c2MZOYTNw@mail.gmail.com>
 <CA+FnnTy2Lk+K8t2uKwc1cAnCm6+RTb72eVRxt9+Y8y+C=sUeyA@mail.gmail.com>
 <473602.1742698901@sss.pgh.pa.us> <CA+FnnTztyXpMxEiKTZhxMtcQ8Nm6D+M1jbfJFfkJYU9dyvTeLg@mail.gmail.com>
 <CAKFQuwZ3-wmpyUEdHUaL7H9RHp-FTxUJjVL3L5A0jqA2bbHXYw@mail.gmail.com>
 <CAKFQuwb6vf1L2O8X_6Qu2VNq9iUhCjbXTc=51702h7yo4dH=8w@mail.gmail.com>
 <CA+FnnTx5n=yCw4+qcRuv-c7ECf=K=tao7j_k=dDp5nPUMJ7t_A@mail.gmail.com>
 <CAFj8pRB5d=0WQYyK7Nho7XY2qY+rvgwzqSmWpVOYBdvC9dcDXw@mail.gmail.com>
 <CAKFQuwZ1=Mi_w-Wt4AkOSO1M+CD-Tg-W7O+9rJb-Fp7Q884fHQ@mail.gmail.com> <CA+FnnTyXFh+sXTOC7HMU0eLDmW0YLhWjX+Z89V9uzg5gtFcHLQ@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 23 Mar 2025 18:15:54 -0700
Message-ID: <CAKFQuwZ04=r5qXzCp0uFr=EuzVbcfq_NUmw5qZuLUHKj4A6nOQ@mail.gmail.com>
Subject: Re: Determine server version from psql script
To: Igor Korot <ikorot01@gmail.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, 
	Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000092f20b06310c58f1"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZ04%3Dr5qXzCp0uFr%3DEuzVbcfq_NUmw5qZuLUHKj4A6nOQ%40mail.gmail.com>
Precedence: bulk

--00000000000092f20b06310c58f1
Content-Type: text/plain; charset="UTF-8"

On Sunday, March 23, 2025, Igor Korot <ikorot01@gmail.com> wrote:

>
>     CREATE TRIGGER playersinleague_insert AFTER INSERT ON playersinleague
> WHEN new.current_rank IS NULL
>
>

When the syntax shows parentheses you are required to write them.

  [ WHEN ( *condition* ) ]

David J.

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

On Sunday, March 23, 2025, Igor Korot &lt;<a href=3D"mailto:ikorot01@gmail.=
com">ikorot01@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote"=
 style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><d=
iv dir=3D"auto"><br>
=C2=A0 =C2=A0 CREATE TRIGGER playersinleague_insert AFTER INSERT ON players=
inleague WHEN new.current_rank IS NULL<br>=C2=A0 =C2=A0=C2=A0<br></div></bl=
ockquote><div><br></div><div>When the syntax shows parentheses you are requ=
ired to write them.</div><div><br></div><div>=C2=A0<span style=3D"font-fami=
ly:monospace,monospace;font-size:14.4px;white-space:pre-wrap">  [ WHEN ( </=
span><em class=3D"replaceable" style=3D"font-family:monospace,monospace;fon=
t-size:14.4px;white-space:pre-wrap;box-sizing:border-box;font-weight:800"><=
code style=3D"box-sizing:border-box;font-family:monospace,monospace;font-si=
ze:inherit;border-radius:0.25rem;margin:0.6rem 0px;word-break:normal">condi=
tion</code></em><span style=3D"font-family:monospace,monospace;font-size:14=
.4px;white-space:pre-wrap"> ) ]</span></div><div><span style=3D"font-family=
:monospace,monospace;font-size:14.4px;white-space:pre-wrap"><br></span></di=
v><div><span style=3D"font-family:monospace,monospace;font-size:14.4px;whit=
e-space:pre-wrap">David J.</span></div><div><span style=3D"font-family:mono=
space,monospace;font-size:14.4px;white-space:pre-wrap"><br></span></div>

--00000000000092f20b06310c58f1--