Re: SQL statements error in pgsql 16 but not in pgsql 12

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 = 19749OR lot= 19750)instead of
> WHERE (lot = 19749 OR lot= 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