Home > mailing lists

Re: SQL statements error in pgsql 16 but not in pgsql 12 - Mailing list pgsql-sql

From	Bharani SV-forum
Subject	Re: SQL statements error in pgsql 16 but not in pgsql 12
Date	July 18 17:50:14
Msg-id	432596330.2235682.1721314214935@mail.yahoo.com Whole thread Raw
In response to	Re: SQL statements error in pgsql 16 but not in pgsql 12 ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses	Re: SQL statements error in pgsql 16 but not in pgsql 12
List	pgsql-sql

tagged mean " add to something "

hope ur picture posted with the sql query, i can see as

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

where the OR is tagged to numeric 19749.

What does "tagged" mean here?

David J.

From: Frank Komsic
Date: 16 July, 21:01:35
Subject: Re: SQL statements error in pgsql 16 but not in pgsql 12

From: Tom Lane
Date: 18 July, 17:57:40
Subject: Re: SQL statements error in pgsql 16 but not in pgsql 12