MIME-Version: 1.0
In-Reply-To: <19472-6b130bcff370911d@postgresql.org>
References: <19472-6b130bcff370911d@postgresql.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 6 May 2026 05:53:58 -0700
Message-ID: <CAKFQuwY95Rsw=P4a+=NJijCTY=+AmV2W7OEF2T14BiQo4S9i4w@mail.gmail.com>
Subject: Re: BUG #19472: CAST(-32768::SMALLINT AS REAL) fails with "SMALLINT
 out of range" but -32768 is valid SMALLINT value
To: "vectorplanck@gmail.com" <vectorplanck@gmail.com>, 
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000592490065125a86d"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwY95Rsw%3DP4a%2B%3DNJijCTY%3D%2BAmV2W7OEF2T14BiQo4S9i4w%40mail.gmail.com>
Precedence: bulk

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

On Wednesday, May 6, 2026, PG Bug reporting form <noreply@postgresql.org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference:      19472
> Logged by:          Pisces Mar.
> Email address:      vectorplanck@gmail.com
> PostgreSQL version: 17.6
> Operating system:   x86_64-windows
> Description:
>
> Issue Description:
> When casting -32768 to SMALLINT and then to REAL using the :: operator,
> PostgreSQL throws an error "smallint out of range", even though -32768 is=
 a
> valid value within the SMALLINT range (-32768 to +32767).
>
> Workaround:
> Use parentheses: SELECT CAST((-32768) :: SMALLINT AS REAL);
> Or use standard CAST syntax: SELECT CAST(-32768 AS SMALLINT);
>

These aren=E2=80=99t really workarounds; this is just how you need to write=
 the
expression given our long-established and not going to change operator
precedence and literal syntax parsing rules.

David J.

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

On Wednesday, May 6, 2026, PG Bug reporting form &lt;<a href=3D"mailto:nore=
ply@postgresql.org">noreply@postgresql.org</a>&gt; wrote:<br><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;p=
adding-left:1ex">The following bug has been logged on the website:<br>
<br>
Bug reference:=C2=A0 =C2=A0 =C2=A0 19472<br>
Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Pisces Mar.<br>
Email address:=C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:vectorplanck@gmail.com=
">vectorplanck@gmail.com</a><br>
PostgreSQL version: 17.6<br>
Operating system:=C2=A0 =C2=A0x86_64-windows<br>
Description:=C2=A0 =C2=A0 =C2=A0 =C2=A0 <br>
<br>
Issue Description:<br>
When casting -32768 to SMALLINT and then to REAL using the :: operator,<br>
PostgreSQL throws an error &quot;smallint out of range&quot;, even though -=
32768 is a<br>
valid value within the SMALLINT range (-32768 to +32767).<br>
<br>Workaround:<br>
Use parentheses: SELECT CAST((-32768) :: SMALLINT AS REAL);<br>
Or use standard CAST syntax: SELECT CAST(-32768 AS SMALLINT);<br>
</blockquote><div><br></div><div>These aren=E2=80=99t really workarounds; t=
his is just how you need to write the expression given our long-established=
 and not going to change operator precedence and literal syntax parsing rul=
es.</div><div><br></div><div>David J.</div><div><br></div>

--000000000000592490065125a86d--