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 1sTjfc-001uBh-Md for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2024 15:00:48 +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 1sTjfb-001UyW-8i for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2024 15:00:47 +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 1sTjfa-001UyL-Vs for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2024 15:00:46 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sTjfY-002M9p-Lr for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2024 15:00:45 +0000 Received: by mail-oo1-xc36.google.com with SMTP id 006d021491bc7-5cbc5b63939so2910663eaf.1 for ; Tue, 16 Jul 2024 08:00:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721142044; x=1721746844; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=emCf8o+741wiOAuksJaev+UK3z7ieTZMjXAgX9FlvnA=; b=jZucVYr2Hux5eH7GwJCyJRsgjB/EVteq6XQwsh5PJ2TfbwoRczZ3YmwsZw40EhhE7r A9O9xXBgHevVqAbdk+fEmWeFeUG347bq8FCYSb4JktoZneVALree+nM9kzsiBZayAqw2 RkEC+8CeDA+7nK9jzwok95Iwg5uROsT3b+vYvrQvwdqADzhxiZOP68BdcKEo0m+6tQU3 t2H7vx3d3f44Sx4bXYETp6/xxZB94y7mCmKmYr46ZKnKAc5cSwC4PAl1jzuWHOIsy8s5 WPeHeh4ydIp5vOuUP8ri5/QWcFzF6IyNdqxIlyK5U3mvmburdl3Dw0Om40quRbYnjeNO D64Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721142044; x=1721746844; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=emCf8o+741wiOAuksJaev+UK3z7ieTZMjXAgX9FlvnA=; b=VvyQ2f92id6R0aMjO37jilWQJySmugIgSdKXrLFPuSIi+NGLBXjjbLVsyHXkOW6ATe MsZf2xp/QrnGdwdO2BM11jaX+j7ClYBBVd5Z/Y/u4eYhMTJxUDk5OFDuGEobgnelLgNu 4nyX8Hz8EPMxF6UX1F8xyabmyj5itVG1PTXTNQePpgaAcMRAHHAZs3qgRLeVDMIq8pxS W03bFYtnJXSZYk/+kI2D8Sp3BoWFOA3r5GGTJENt/gurTm5C7P9sX76gIbZpVE7nwSXp cDoD+UDeZBuNQa4OiAhNh/OTU7GwOaYaWSTuqco8gjo2B5ypgVWrLvR7pFdJrv+ouaVm VgZA== X-Gm-Message-State: AOJu0YxRz/BZ47Z609fwHt6z2+MERkbAi/l3TDBvt7Z3xDwcXBTtPPWq aPcikv9u6IRcA+hkEnB2sxKUIQL9Z4lExOfLYVVWLjPtlj+vfmfDGYxFt+qd/JsMEWuBsAUEbWA 7dOCXk+IYiHQn+eTV82Zb/PZA9nM= X-Google-Smtp-Source: AGHT+IG4U/uYt7uZZjb8M8ZQwTjIKrb+svH3VLg4ODeVZZoLvs43IzYo2XKgzhvX9tRc9nTwp+eFsiGop5Nfnk1i4nQ= X-Received: by 2002:a05:6820:2d0a:b0:5c4:13c0:f03f with SMTP id 006d021491bc7-5d2898e6e8amr3101186eaf.6.1721142043748; Tue, 16 Jul 2024 08:00:43 -0700 (PDT) MIME-Version: 1.0 References: <151842168.569875.1721141786874@mail.yahoo.com> In-Reply-To: <151842168.569875.1721141786874@mail.yahoo.com> From: "David G. Johnston" Date: Tue, 16 Jul 2024 08:00:06 -0700 Message-ID: Subject: Re: SQL statements error in pgsql 16 but not in pgsql 12 To: Bharani SV-forum Cc: "pgsql-sql@lists.postgresql.org" , Frank Komsic Content-Type: multipart/alternative; boundary="000000000000203144061d5e9cdb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000203144061d5e9cdb Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Jul 16, 2024 at 7:58=E2=80=AFAM Bharani SV-forum wrote: > cross check > WHERE (lot =3D 19749 *OR* lot=3D 19750) > > where the OR is tagged to numeric 19749. > > What does "tagged" mean here? David J. --000000000000203144061d5e9cdb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable --000000000000203144061d5e9cdb--