Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUSSe-003BER-NI for pgsql-sql@arkaria.postgresql.org; Thu, 18 Jul 2024 14:50:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sUSSc-00HX1G-Fq for pgsql-sql@arkaria.postgresql.org; Thu, 18 Jul 2024 14:50:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUSSb-00HX07-Kc for pgsql-sql@lists.postgresql.org; Thu, 18 Jul 2024 14:50:22 +0000 Received: from sonic304-21.consmr.mail.ne1.yahoo.com ([66.163.191.147]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sUSSY-000CvN-Jk for pgsql-sql@lists.postgresql.org; Thu, 18 Jul 2024 14:50:20 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1721314216; bh=MATOKYXx5lifPPMnqrSOqKQ/LcONZXvPljdqzvUp6FM=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=g8etpSwXCmTvYmdBekmyY9aKhGFxP/4BpnokKgAFBDSWwHslnGlzhZJrbWNVaJg74aiskHDgmGbRYUUTD97Q5yMuzCfsiZLLeT9UYiq5oUiiCte1tIfeOJJ3WWh7DfaUk3VPXWB98ErH5eMFcSxkdAtfvms1xCweJ9ZkTTGWONclOmKt1h4iSjNkkwwkmcdbwHI177wNmBsVWKYyJaPjSttLQjh1gBr3mqDX0nZmSqPk2YlmLcUtsz2W7r/onylpbCsZwQRhIIiJqtYoJr8noRqjSvEeSzD3aRBEuLaQt4dIPky5BYW8SWa5+p7FKUDttNvnKcnzzB+O+2vWvBBB/A== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1721314216; bh=Pp1J8HAiTIw6/vsc2J3zgFKCJSSd+K2fhO360OotZMb=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=Zj9ngbRHHoyBZ8b/onmoyu6tUcfrV8l3rOiAyfrKqwIcYkOcU0wBPFzW066krBNiGoyT/P67DMXD9TtLcpyNNCPKsU+2JaynEW0DUCVPti3a+mKS5U4q4c+/SNocukrtbRBEqKBd3EWXu16XnF+81ZzFmnvJ1PB0+JHjUtDgCsAi3LxCkfvtk9pQvRgaNMPzf6M/ZfH6doByz2biG60/YagH7L5ESyxPRVSwI43ZNrhng/UaGc2g75kT/Npv0QBeu/dtqnqu+kmzSLeQqloI9DwhPD+QxBydK/k2/043yzSRVkrQwZmf3D6I4bpysIF4sxkMA0mmANHKe5iAqlv1rg== X-YMail-OSG: D.WlUIUVM1mZmt.WcUQjyueqLN1X5WAHwYy7uI01QrvtZ3oqzCSre7A1.MV1COJ GRLLMyJ7jetHsUBC0fhMoaQ3XkwyflT5rSh8fz5SjRhAEUxw3wqC.1ZMAgi5OcJY.TrIU1x_ky4Z vWQAHTCcAkGi4FRQnq0Qx9lIfjGQ3yw45LcLtKX2JRo4A9pDOghZcdXpKpHGE1j2FWCRkSHseOu0 MzkkdMXmpVWzwQfDfXkM435ELIVz59pizyNWw7AuwuEHFoynvsji0TmfLBHuBGzXG8O.0a8wF9m. gwFrPI.s.USOqrRJlfeXWd87R0pfB8xkBT5NCn8.JL0PPn51UjxCYwVuaJgXiMB58jPz8IN6hP7W 4wqyNA8byGOSOqJdIUilaUOQJwUf743AWXFf1XrrIbBk_kC0FYjJkP0NtDAcsUm9SjpB3eRuqWRP BvOjd0hMtdjg2X_DTLwoLd4.vfqvvk6d4jqY1jvX34Wk27q.J06aLoyCpoPtKOuq8rXTHMCDSTyD 1aVXjXJ01N9vuAFcYCqUQI2kUgdnV7lrrv4iWKVd1nYRm7Slit0zHneIHlhPxmIWbsnwFszZ2Xs8 jhM4CHuO1Db2H3DtnwYZWY3G.5sIBw8y4Mc5T49rv_GkcRvj8ftlQll5BzEtSsOhEVNUKF7Rj0Wk YpMY8P9zW4j8ldDQzc6S4ON2ufDYhgdL5M2kpznIbUu4VKhwOgppBsQZJt6CtVGgUgBiuy.qf3J6 N860Z_37IROUvDMX_xFGBM83gbeY8ev4HD3s6F72RhrtNLZjuCD6hafIWe1esR1vtwj3zLHeQQVd DzDJMN6MyO0AjpZSD.KUdZOnl1CGj4xCUV7E0pVNVp1Xmo1FiCo59b1qADWYMfZxkXx7AdIuoVw8 0za5JbE9e9YzZe0n2pN3VqpX2VV0DyCjcM3gCSR7zTg85bQQ2E_wrnZv3u0ZxVG4v.z4Z4NMC2dK nTQzT58ea9vg6xoA3RlSIrsfLKrKlkG_XVKqcgJ0iJDIhJRSlfpPxUyz1l74fKwPmtHg1MBUebKA B50DpLy5KqgA0CUMZu0rEMjE_6t.7zwJJOU7HOf1oYfQ1LoB2a7HDxvaL6GY1rAz.ieD.6ca1TQK Bgy_x884mbCedjk7oJEb4qmaBIFbIdf7Bk9zSkr1s8vvs1rGDPQerp9NyjwNUV8UEQNzKVmX.86G oVG6iJXBpZY6AavWRHXHeOBET.WCzkBmJKqlnuENer9qXR.CiA7.NE.T7fS.flGPjfFLjtP3Ibtn 7ecQXzimRU6qKroHAeTgF24H7CJv1cM7_emjgAJFfAMiLUM6K7RJKNq_V_SjLVOXhU.PbItw3oOa Vf48.yC7FIc1SyCbXyLF3AuqI4o8bwKDX6adV0q5se6SrugEH7VNBLbgxS9kEH4iEGwjR6Ye5DEq _pQYXUANS5H4IHlt1Uk.etYoXnSgwvYTVy7Fb2feUPX7skP73dgAWS7kws_w1EzbYRqt7PP2xCqN 7fpCDkRM8rwhpaXiPhfOPDW_1uebdd0iQgIVsarFCtxbl3ae4Bkz9Z12YY0Fo7t08jwQi52LBzKn Kmwc8SAVV5QIrTtlwP4k_u3IJKy6nBIRGHHFMJ4fdiiWiV4HMdRzrNb2dKgCljOhJVSyo5VPvv6q DdWglRJfbtaN17Qg3rJkdvhCpKqUYdXA8K_OALcNKNLlIisF2pp62dzMudmsMcjUcTbZHA07H_9J h1NjgLAfDgAQ6T_JzlxucfBB9BHQw..IQBSE6Jguk0yBmepnHeiFiEVKHTt7RNq3Iy1RR3bqzFnY UPfzmMUI3ircDS_fj1Ec.7OwHrrRBGcpY7hgGMxiKBiiMBipvH7FUn3dFpRynUrUI.qI7wgXdVIg 6l1um0CEDtjrV2NrI26vz2XzTsm5XOJEa4oRxlVYoLQnpt1DFHtvYcjD0oCuq7qMYtxcsrGs_YjU DatHGxoHUmss307b9Wq1R_RHcwnNk3fLnMqAGJjrW4kAyEW4NC9aM_QvkwkArDp7RuCTyVOTfQRD ohLS8loiIOHwxTCdhEmimcTNz6F.QPwWP8i7h5m0Ite20IpUsgUO7is.Obp9_Tga45bVAKqWUL4j HRaO9SV5lEqVK2ZIG2wrgOa6SQTbEYcDuNtNf3Ug_hVKfK7ieq.5.qdW_.K43OOgpSi.L7.4rG6B szTPFEdrivUf.DJDI0hTvPOY2A9e_5k0KWdu3u_5kAtzvDlcTH9XkGxO.u9MUjGpYcwemIduLT.2 oM2UC8q0TK2Uqc2iVnwgkImJfjOOLVTtM9ALiE7Luucegum.47o43kHAleqYhRNc- X-Sonic-MF: X-Sonic-ID: f9778f54-6cb0-491c-ba30-ab5f63e5827f Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.ne1.yahoo.com with HTTP; Thu, 18 Jul 2024 14:50:16 +0000 Date: Thu, 18 Jul 2024 14:50:14 +0000 (UTC) From: Bharani SV-forum To: "David G. Johnston" Cc: "pgsql-sql@lists.postgresql.org" , Frank Komsic Message-ID: <432596330.2235682.1721314214935@mail.yahoo.com> In-Reply-To: References: <151842168.569875.1721141786874@mail.yahoo.com> Subject: Re: SQL statements error in pgsql 16 but not in pgsql 12 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2235681_1006015694.1721314214932" X-Mailer: WebService/1.1.22501 YMailNorrin Content-Length: 4776 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_2235681_1006015694.1721314214932 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable tagged mean " add to something " hope ur picture posted with the sql query, i can see asWHERE (lot =3D 19749= OR lot=3D 19750)instead of=20 WHERE (lot =3D 19749 OR lot=3D 19750) Hope u have understood On Tuesday, July 16, 2024 at 11:00:54 AM EDT, David G. Johnston wrote: =20 =20 On Tue, Jul 16, 2024 at 7:58=E2=80=AFAM Bharani SV-forum wrote: cross checkWHERE (lot =3D 19749 OR lot=3D 19750) where the OR is tagged to numeric 19749. What does "tagged" mean here? David J. =20 ------=_Part_2235681_1006015694.1721314214932 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
tagged mean " add to something "

hope ur pictu= re posted with the sql query, i can see as
WHERE (lot =3D= 19749OR lot=3D 19750)
instead of
WHERE (lot =3D 1= 9749 = OR lot=3D 19750)

Hope u have understood
=20
=20
On Tuesday, July 16, 2024 at 11:00:54 AM EDT, David= G. Johnston <david.g.johnston@gmail.com> wrote:


=20 =20
On Tue, Jul 16, 202= 4 at 7:58=E2=80=AFAM Bharani SV-forum <esteembsv-for= um@yahoo.com> wrote:
cross check
WHERE (lot =3D 19749 OR lot=3D 19750)

where the OR is tagged to numeri= c 19749.


What does= "tagged" mean here?

=
David J.
------=_Part_2235681_1006015694.1721314214932--