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.96) (envelope-from ) id 1wbNpQ-002VJ2-09 for pgsql-bugs@arkaria.postgresql.org; Sun, 21 Jun 2026 19:27:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wbNpO-003nRF-34 for pgsql-bugs@arkaria.postgresql.org; Sun, 21 Jun 2026 19:27:34 +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.96) (envelope-from ) id 1wbNpO-003nR4-1p for pgsql-bugs@lists.postgresql.org; Sun, 21 Jun 2026 19:27:34 +0000 Received: from mail-dy1-x1330.google.com ([2607:f8b0:4864:20::1330]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wbNpN-00000001Tx1-07iH for pgsql-bugs@lists.postgresql.org; Sun, 21 Jun 2026 19:27:33 +0000 Received: by mail-dy1-x1330.google.com with SMTP id 5a478bee46e88-30c03b09e02so5973423eec.1 for ; Sun, 21 Jun 2026 12:27:32 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782070052; cv=none; d=google.com; s=arc-20240605; b=Cvo2s+1PjOTJp5f4YZUhqhA5ZPiF7+pT4hU3lcoMQ4U6Pr+rUTUM6DjoTpOxd5a53g C09ISMIvhIMPPX4q+kl69u6SnVnD6zYpYfTr12GsFN3vrU0M8oSldFmIMvh7ajI71TKf 5GqDqVjUrDLM6xGCcZ/McCOFDzxM0UUWMZkwjpyxVBdNAZn7ae5BxeMyTuJCKO8B38eL IgemI21gHQ/3zTmyplRTSKAu/LVufp3KTj5y38VBqjWQM7ECuEABa1Qt1qHbEHIRmXwm atrXjVsnHQzn42t42MOt1hIemYe4zbCUy28qodzRP7AYCoRNeutBfYZ66VUC6SpI8Ndq csOQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=fd1WRMPR2fyUHme0Dyukd9ys9muqwL3SPqtoccKqoZg=; fh=T6h+55ScEzXvdY3eX+t1ubMe/Lp026Eh1E/EPlVxzDU=; b=U02ENezSv1lVYSdoDGUMuniO6/sIb4T6r6IA7YmdleeMRzLD6OJF+poMXSMw3tIXCy q1A+5BfoKXywpuXUgJGXEZGIxv4EFw/nIXI4oL8i4tiFpGAfC4zws36AftayGHe9sfEk hM9Ev0SETPhylQNtGe2i2FlixgecaSEStySZ9aSXPLXaNjn2M1DpbpyV3Vx7AcSTjeWH v6s8ZP2kLkOR5xDS784ksD/z3a7H6hCtX+7PiwlRL6WUyvNgqAhGxVlq7pQkJCXjqe8g 09jsapGgBmbBKqVg58QvhBL5zMn1GkCuoBpjtMqgQfcut2mUC6jiUrA7+OOFzSRgfFMf WFTw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1782070052; x=1782674852; 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=fd1WRMPR2fyUHme0Dyukd9ys9muqwL3SPqtoccKqoZg=; b=oSz8MAsq40snGkIGi8bix16B64Pv+T0jlWRsAtxrNoSnnAF5fxhAserQEmrEoKPWwQ FQxcYscfpUcY6audpWqGFGDhr5PmmCEbF3qrsmCoc70kxVi+PHGTsTg8dxystvPZ57EP nFtg1ghZZ4J87eiYHFshZpwF2X0kZw6zyKPphBOTStw5LnBBKap0eXF5oZP9rR6/1FdM 2sa/Cjv7ls+Q5N776xVm1THyzspON8ehPvZDeII1bxDHtA0os+0cFG1XvPXB7bCAbBsa SQIITydaOqi3qadpJTDKGnWH3pRNx2hZu2laAJq1Fn3ztWweHHIGlFtgvjcl1pPrL401 HZjA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782070052; x=1782674852; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=fd1WRMPR2fyUHme0Dyukd9ys9muqwL3SPqtoccKqoZg=; b=dNu/w71ocz/KhELcCK8cukxnzoc3TfXLL1y8o0x3lwoEPYAp+7DGpjg9x19WmH7spk 3PGylnnFsDK9rp+3bUuKzGVhqwVzYzsKHO8dkmbcMRloHTIDHTXh1eI1zgiUXKEiy83U 0stIH0KCWnoNxgCE7JbcB7GzjmDqNmlJORkDSkLgt4mDlhWuIcV0A7iHLs+3nqIeLt2r NCbGrxaO8RQzpZBWjn7lLqMUweulCMlgpxnLKGo8wwePc3UKktEDH5j1n2eL1qIdcroS xcG5ULF2/vWmwWwnCvSrg3gYxnkDoEENz+m3qVKA+szY/KK88EhSlTNcT/GfGB3jnnga JdpA== X-Gm-Message-State: AOJu0YznzxDe+AwpRU1nYWv1VfLz3c+W19u94XTW4KyO4lcGFfZ0MxS9 xf+6jFRY7JvrifYAQABt8sy5tllD1Y6zjnK0Qtb30xFzNUe7v/HffCGwj2TV6Q00LQageM7o3tM OSdrx/I4Vze+qFmeJz+KOA1MMR2prVEE= X-Gm-Gg: AfdE7cng5KWxV+zYqcWEigUQGmLoPHQnRcIiGC+TTN/qetndQRsKRe/pbY7mjrL77iA fcGRsHHE1nm3V8GBnyi3L+UxHKX5CUbTHg1yoznaN9H841giE+UxErOfFtSmTM1VJKM7JtEZ7YO kLuE8w7/ozIZApWwpZZBlEPlgayjK+EHrNyM8ptl57pMHCpkqEkLutSFkMr4mOehkFYY5OhNCov YHCGeEw/UQPkt4JjYoQ8gEneG6rAI70O4we4CcUHIUpVMuLgwOWOhgg4r/rJPQVL5QQ9CRP X-Received: by 2002:a05:7300:d507:b0:30c:b2:eceb with SMTP id 5a478bee46e88-30c0d0b262emr8012656eec.23.1782070051628; Sun, 21 Jun 2026 12:27:31 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: carl clemens Date: Sun, 21 Jun 2026 19:27:20 +0000 X-Gm-Features: AVVi8CcYakkoxe5VWO34avtPjFaceWOVojKUcBimUDRN3gTwTUwYGVwRGoAfrT8 Message-ID: Subject: Re: psql variable substitution in plpgsql loop To: "David G. Johnston" Cc: "pgsql-bugs@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000646c160654c8845b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000646c160654c8845b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable ok, no problem. Thanks On Sun, Jun 21, 2026 at 6:17=E2=80=AFPM David G. Johnston < david.g.johnston@gmail.com> wrote: > On Sunday, June 21, 2026, carl clemens wrote: >> >> psql fails to populate a table in variable substitution. >> the variable being within a plpgsql "goto" loop looks suspicious >> > > psql will not modify string literals when performing variable substitutio= n. > > David J. > > --000000000000646c160654c8845b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
ok, no problem.

Thanks

On S= un, Jun 21, 2026 at 6:17=E2=80=AFPM David G. Johnston <david.g.johnston@gmail.com> wrote:
<= /div>
On Sunday, June 21, = 2026, carl clemens <cclemens968@gmail.com> wrote:
psql fails to populate a ta= ble in variable substitution.
the variable being within a plpgsql "= goto" loop looks=C2=A0suspicious=C2=A0
<= div>
psql will not modify string literals when performing var= iable substitution.

David J.

--000000000000646c160654c8845b--