MIME-Version: 1.0
In-Reply-To: <CAFj8pRB5d=0WQYyK7Nho7XY2qY+rvgwzqSmWpVOYBdvC9dcDXw@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>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 23 Mar 2025 12:27:19 -0700
Message-ID: <CAKFQuwZ1=Mi_w-Wt4AkOSO1M+CD-Tg-W7O+9rJb-Fp7Q884fHQ@mail.gmail.com>
Subject: Re: Determine server version from psql script
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Igor Korot <ikorot01@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="000000000000ed781706310779e4"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZ1%3DMi_w-Wt4AkOSO1M%2BCD-Tg-W7O%2B9rJb-Fp7Q884fHQ%40mail.gmail.com>
Precedence: bulk

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

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@gmail.com> na=
psal:
>
>> 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 1=
30001 in
integer format.

David J.

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

On Sunday, March 23, 2025, Pavel Stehule &lt;<a href=3D"mailto:pavel.stehul=
e@gmail.com">pavel.stehule@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"><div dir=3D"ltr"><div>Hi</div><br><div class=3D"gmail_quote"><di=
v dir=3D"ltr" class=3D"gmail_attr">ne 23. 3. 2025 v=C2=A019:31 odes=C3=ADla=
tel Igor Korot &lt;<a href=3D"mailto:ikorot01@gmail.com" target=3D"_blank">=
ikorot01@gmail.com</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex">Hi,<br>
<br>
[code]<br>
SELECT current_setting(&#39;server_<wbr>version_num&#39;)::int &gt; 130000 =
as v13<br></blockquote></div></div></blockquote><div>=C2=A0</div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc sol=
id;padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_quote"><div>SELEC=
T current_setting(&#39;server_<wbr>version_num&#39;)::int &gt; =3D140000 as=
 v14</div></div></div></blockquote><div><br></div><div>IOW, you can=E2=80=
=99t use &gt;130000 because that will match v13.1 which is 130001 in intege=
r format.</div><div><br></div><div>David J.</div><div><br></div>

--000000000000ed781706310779e4--