From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bharani SV-forum <esteembsv-forum@yahoo.com>
cc: "David G. Johnston" <david.g.johnston@gmail.com>,
        "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>,
        Frank Komsic <komsicf@shoeicanada.com>
Subject: Re: SQL statements error in pgsql 16 but not in pgsql 12
In-reply-to: <432596330.2235682.1721314214935@mail.yahoo.com>
References: 
 <DM4PR05MB92551C285B81BB5FB12F1BC6B3A12@DM4PR05MB9255.namprd05.prod.outlook.com>
 <151842168.569875.1721141786874@mail.yahoo.com>
 <CAKFQuwbWQokwEDszfDw+UL_bdBYNbjnEa8XHTOcSPyRW5TxXUA@mail.gmail.com>
 <432596330.2235682.1721314214935@mail.yahoo.com>
Comments: In-reply-to Bharani SV-forum <esteembsv-forum@yahoo.com>
	message dated "Thu, 18 Jul 2024 14:50:14 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3709210.1721314660.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 18 Jul 2024 10:57:40 -0400
Message-ID: <3709211.1721314660@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3709211.1721314660%40sss.pgh.pa.us>
Precedence: bulk

Bharani SV-forum <esteembsv-forum@yahoo.com> writes:
>  tagged mean " add to something "
> hope ur picture posted with the sql query, i can see asWHERE (lot =3D 19=
749OR lot=3D 19750)instead of =

> WHERE (lot =3D 19749 OR lot=3D 19750)

That's not a great choice of word.  In any case, the point here
is that the SQL standard requires some whitespace between a number
and a following word, and starting from PG 15 we're enforcing that
to reduce ambiguity.

			regards, tom lane