Horton

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

Bharani SV-forum <esteembsv-forum@yahoo.com>

View thread View on postgr.es
From: Bharani SV-forum <esteembsv-forum@yahoo.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>, Frank Komsic <komsicf@shoeicanada.com>
Date: 2024-07-18T14:50:14Z
Lists: pgsql-sql 
 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)

Hope u have understood
    On Tuesday, July 16, 2024 at 11:00:54 AM EDT, David G. Johnston <david.g.johnston@gmail.com> wrote:  
 
 On Tue, Jul 16, 2024 at 7:58 AM Bharani SV-forum <esteembsv-forum@yahoo.com> wrote:

 cross checkWHERE (lot = 19749 OR lot= 19750)

where the OR is tagged to numeric 19749.


What does "tagged" mean here?
David J.

Commits

  1. Non-decimal integer literals