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 ) id 1twWIm-00FEc7-Vt for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 01:08:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1twWIl-008vXm-7Z for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 01:08:27 +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 ) id 1twWIk-008vUd-RG for pgsql-general@lists.postgresql.org; Mon, 24 Mar 2025 01:08:26 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1twWIi-000ll6-13 for pgsql-general@lists.postgresql.org; Mon, 24 Mar 2025 01:08:26 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-6febbd3b75cso31907827b3.0 for ; Sun, 23 Mar 2025 18:08:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742778502; x=1743383302; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Y0/v/MtQ6G32raYngVwPcqiuFdscTtUh3HT4lO/kb9w=; b=FVMvtYbXoTRanmcojaLZqJYcgYIAbTN9XPw6Q9ZJ4+9mHrESlDcCsqXkTJIc87KZwU 8GWdo0X/vaWF1zAs/oHtsREsWGPBuIe9tmVtlEBwkWlo+upEnyY4N0mh++ekHubfSWbp 96ecT8Q7AoASgcr1PS7a9rzCbqESzTuW7VEzqZ3eg4/vds/BykfuAFGGYO+aFBo0xsU9 8AOROh9neg8c1M/VlKhXBK5zYpAlaN/eVSYWbSlPIKQfMI141yeOG4GrghIDHjYYcwdu Ds3zpLxhglM8zerl48bxTXiRN5VlEbYn4ix8XdOvCyVqjse40d/w48K1Hvx1/ZiJZwvG ZzPQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742778502; x=1743383302; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Y0/v/MtQ6G32raYngVwPcqiuFdscTtUh3HT4lO/kb9w=; b=LL8Esihn/Ra/aeO3Od+LvXBRQ2HznE3hq9g10uEOrb6CGF7+hopGttdGbO5qXgO5Vy h2Lt5ezaJFqA6Z8w+2RjADvxeU5Z6ByISr/O4tS7tPoyia+tgSywdIqtaRrHKZcGHjdK /rXe86tbFvO/3Eq+9GXIpIGCABsUjIxQ41TrxHb0nMSoiub2QzVzc85ySIHph0gsCvFq /v8YP4bLv2Uax5UtvGiOw6zVDJcs2fiOe8EmqOzJB5PwcCzXsiarmhACcj4U2ltSsPho K9lzFrGLv4lmLGleGkFcA0J4/thnnTnGHelFaJaV/+ZqyBY5F2rErtfh8UEFyzVloHOs sC4g== X-Forwarded-Encrypted: i=1; AJvYcCXCRXYc6mlJybPBqPt+6FljWCIoooY1k73zNrO+tu9rd+ojWj6rZUvGgQp+hB5GDadPWHw1mls6YgWgd5BC@lists.postgresql.org X-Gm-Message-State: AOJu0YzyK1E6cr4aQRLfpwJuhOuu2oxx0EmUh2pdIF2lwQA6oVEY0HnU idlNHGdb3eUSmW8XqmbT/hyvWJkCRS7Zn0TPthUInWTWnarYrdhbl+UC/fyl0AEskZIc0r6LXu0 dk06suF0UCPBbViUz3XP311Nqlu4= X-Gm-Gg: ASbGnctDfOkKCLLtvQrHibbXmgCyCAtxJMzGoA7P9NGfu82oyJQD6vZE5XVOz4QFhtf wWu1nF7l7czqAMFgcdYiVgsgGoQD42uI02DFc6kUsqFOTqfiQ5Fqs6YJgmz9+HK5awgApJHoo/q 5Euho2fGIOUKwkGID/lOTQ0ivmp70XJ4xOcfuNyhHAKcHOMIsn04MB2F4GVFuz X-Google-Smtp-Source: AGHT+IG0/YD5hPtJ46x2R+O8pMwwYP9X9UmPgIQ56SLIWp3zneH6x0wv36V8cu9hG5Tpj346/LrCvqgeMzEnK6Z6rwo= X-Received: by 2002:a05:690c:350d:b0:6fd:2b7d:9a4e with SMTP id 00721157ae682-700bac67ce9mr133795587b3.18.1742778502366; Sun, 23 Mar 2025 18:08:22 -0700 (PDT) MIME-Version: 1.0 References: <90741d5f-5cda-4c4a-84f4-c470129732f4@aklaver.com> <473602.1742698901@sss.pgh.pa.us> In-Reply-To: From: Igor Korot Date: Sun, 23 Mar 2025 20:08:11 -0500 X-Gm-Features: AQ5f1Jpo45YpBm1b69Qgcf1p4JvAEItvHc_ygg3Tvmyyzn7igqGNqfNDcc-Vg0Y Message-ID: Subject: Re: Determine server version from psql script To: "David G. Johnston" Cc: Pavel Stehule , Tom Lane , Adrian Klaver , "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000008e4f8006310c3d2d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008e4f8006310c3d2d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, This is what : [code[ \else DROP TRIGGER IF EXISTS playersinleague_insert ON playersinleague; CREATE TRIGGER playersinleague_insert AFTER INSERT ON playersinleague WHEN new.current_rank IS NULL BEGIN UPDATE playersinleague SET current_rank =3D 1 + (SELECT coalesce( max( current_rank ), 0 ) FROM playersinleague WHERE id =3D new.id) WHERE rowid =3D NEW.rowid; UPDATE playersinleague SET original_rank =3D current_rank WHERE row= id =3D new.rowid; END; \endif [/code] And I'm getting this: [code] \else DROP TRIGGER IF EXISTS playersinleague_insert ON playersinleague; psql:draft_pg.sql:44269: NOTICE: trigger "playersinleague_insert" for relation "playersinleague" does not exist, skipping DROP TRIGGER CREATE TRIGGER playersinleague_insert AFTER INSERT ON playersinleague WHEN new.current_rank IS NULL BEGIN UPDATE playersinleague SET current_rank =3D 1 + (SELECT coalesce= ( max( current_rank ), 0 ) FROM playersinleague WHERE id =3D new.id) WHERE rowid =3D new.rowid; psql:draft_pg.sql:44272: ERROR: syntax error at or near "new" LINE 1: ...eague_insert AFTER INSERT ON playersinleague WHEN new.curren... ^ [/code] What is the problem niw? Thank you. On Sun, Mar 23, 2025 at 2:27=E2=80=AFPM David G. Johnston < david.g.johnston@gmail.com> wrote: > > On Sunday, March 23, 2025, Pavel Stehule wrote: >> >> Hi >> >> ne 23. 3. 2025 v 19:31 odes=C3=ADlatel Igor Korot n= apsal: >>> >>> Hi, >>> >>> [code] >>> SELECT current_setting('server_version_num')::int > 130000 as v13 > > >> >> SELECT current_setting('server_version_num')::int > =3D140000 as v14 > > > IOW, you can=E2=80=99t use >130000 because that will match v13.1 which is= 130001 in integer format. > > David J. > --0000000000008e4f8006310c3d2d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,
This is what :

[code[
\else
=C2=A0 =C2=A0 DROP TRIGGER IF EXISTS playersinleague_insert ON playersinlea= gue;
=C2=A0 =C2=A0 CREATE TRIGGER playersinleague_insert AFTER INSERT ON players= inleague WHEN new.current_rank IS NULL
=C2=A0 =C2=A0 BEGIN
=C2=A0 =C2=A0 =C2=A0 =C2=A0 UPDATE playersinleague SET current_rank =3D 1 += (SELECT coalesce( max( current_rank ), 0 ) FROM playersinleague WHERE id = =3D new.id) WHERE rowid =3D NEW.rowid;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 UPDATE playersinleague SET original_rank =3D cu= rrent_rank WHERE rowid =3D new.rowid;
=C2=A0 =C2=A0 END;
\endif
[/code]

And I'm getting this:

[code]
\else
=C2=A0 =C2=A0DROP TRIGGER IF EXISTS playersinleague_insert ON playersinleag= ue;
psql:draft_pg.sql:44269: NOTICE:=C2=A0 trigger "playersinleague_insert= " for relation "playersinleague" does not exist, skipping DROP TRIGGER
=C2=A0 =C2=A0CREATE TRIGGER playersinleague_insert AFTER INSERT ON playersi= nleague WHEN new.current_rank IS NULL
=C2=A0 =C2=A0BEGIN
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0UPDATE playersinleague SET current= _rank =3D 1 + (SELECT coalesce( max( current_rank ), 0 ) FROM playersinleag= ue WHERE id =3D new.id) WHERE rowid =3D new.rowid;
psql:draft_pg.sql:44272: ERROR:=C2=A0 syntax error at or near "new&quo= t;
LINE 1: ...eague_insert AFTER INSERT ON playersinleague WHEN new.curren...<= br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ^

[/code]

What is the problem niw?

Thank you.

On Sun, Mar 23, 2025 at 2:27=E2=80=AFPM David G. Johnston <david= .g.johnston@gmail.com> wrote:
>
> On Sunday, March 23, 2025, Pavel Stehule <pavel.stehule@gmail.= com> wrote:
>>
>> Hi
>>
>> ne 23. 3. 2025 v 19:31 odes=C3=ADlatel Igor Korot <ikorot01@gma= il.com> napsal:
>>>
>>> Hi,
>>>
>>> [code]
>>> SELECT current_setting('server_version_num')::int >= 130000 as v13
>
>=C2=A0
>>
>> SELECT current_setting('server_version_num')::int > =3D= 140000 as v14
>
>
> IOW, you can=E2=80=99t use >130000 because that will match v13.1 wh= ich is 130001 in integer format.
>
> David J.
>
--0000000000008e4f8006310c3d2d--