Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1twWiV-00FI60-H7
	for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 01:35:03 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1twWiS-009RVc-RT
	for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 01:35:00 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1twWiS-009RVU-GC
	for pgsql-general@lists.postgresql.org; Mon, 24 Mar 2025 01:35:00 +0000
Received: from smtp92.ord1d.emailsrvr.com ([184.106.54.92])
	by magus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <xof@thebuild.com>)
	id 1twWiP-000lxO-2f
	for pgsql-general@lists.postgresql.org;
	Mon, 24 Mar 2025 01:35:00 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp4.relay.ord1d.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 4C606401DE;
	Sun, 23 Mar 2025 21:34:55 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\))
Subject: Re: Determine server version from psql script
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CA+FnnTyXFh+sXTOC7HMU0eLDmW0YLhWjX+Z89V9uzg5gtFcHLQ@mail.gmail.com>
Date: Sun, 23 Mar 2025 18:34:24 -0700
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
 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-Transfer-Encoding: quoted-printable
Message-Id: <B40C1523-D5D8-41FA-A795-05B6D495E794@thebuild.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>
To: Igor Korot <ikorot01@gmail.com>
X-Mailer: Apple Mail (2.3776.700.51.11.1)
X-Classification-ID: f162172e-e49e-49f2-8bfb-f5742ca18f04-1-1
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/B40C1523-D5D8-41FA-A795-05B6D495E794%40thebuild.com>
Precedence: bulk



> On Mar 23, 2025, at 18:08, Igor Korot <ikorot01@gmail.com> wrote:
>     CREATE TRIGGER playersinleague_insert AFTER INSERT ON =
playersinleague WHEN new.current_rank IS NULL

The WHEN predicate has to be enclosed in parenthes:

	CREATE TRIGGER playersinleague_insert AFTER INSERT ON =
playersinleague WHEN ( new.current_rank IS NULL )=