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 1v1SiS-008vAX-0R for pgsql-general@arkaria.postgresql.org; Wed, 24 Sep 2025 16:51:40 +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 1v1SiQ-00Eb3J-9J for pgsql-general@arkaria.postgresql.org; Wed, 24 Sep 2025 16:51:38 +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 1v1SiP-00Eb3B-VP for pgsql-general@lists.postgresql.org; Wed, 24 Sep 2025 16:51:37 +0000 Received: from mail-ot1-x334.google.com ([2607:f8b0:4864:20::334]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v1SiN-002DKW-1v for pgsql-general@lists.postgresql.org; Wed, 24 Sep 2025 16:51:36 +0000 Received: by mail-ot1-x334.google.com with SMTP id 46e09a7af769-74ed00220f6so1270a34.2 for ; Wed, 24 Sep 2025 09:51:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758732695; x=1759337495; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=D6WFeRFyebxpkJm20n7UEnFBpOZo8zNiDRKR15KNGtQ=; b=MGxXHP5pjWdMC5jqFUy3J4Yal8xljkAIMEeZ1mkdUTBYxdlMAg7LNZJLEq5M7yDMV7 0Q9AEoXOcxldaa+4+huveOTZWUrHatm+yoG4zhNrdKdJMILFA4+Ut/sOrcXwo6GShWPx pgb2tqJbVFH94V4idEWJhd/pdzRJfCdhKjYSJEXif5y8eK5EwBz6MSOihk0AljfTN44h n5EWKM/Xx5XZLWtQ5y8IMk6M8bVCkfZfAdeLsbiW3OB/T/wtcmGZOzjAgZVcdv5fDFjZ cuSyNuZdBjI4u0S3GLBZqxDCIx1SvS9hYIdfefGgx2kepLoUSNzHg9BdRwXOXaQx+PW4 d0fw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758732695; x=1759337495; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=D6WFeRFyebxpkJm20n7UEnFBpOZo8zNiDRKR15KNGtQ=; b=c452evvF2FPMqD3GSzzpVnqIaXU54HPvuAa+rqr0ZacFhgOHvVTAOOj0biHx0KPpRU mokNIlxG2vJLUbTQFPLbpEncxGFw8osXWTA5O813o06Jx79i7w/KZMAbdDTZEjdSWDSe dsuq29d93dbrYTal7uwJsoxA44uV+ZWrntl4shhvVpDkfHW9apxPxKEADZnqDHzoq21f ZmSKpbrh/38mrrASkucsKEcNWTJnVV0QvO1ZvEGnsF2i6ZVP/obFMZgDPIiHZhueLrg9 wAcwOqcpbbee4csTxgDnm78YEexDbZZV8SxEwaRSipmSr+roUPcjPe6VgzIAXXHdyREQ Pjaw== X-Forwarded-Encrypted: i=1; AJvYcCXstlMqGgOACcwYW2LQ3PQClgP/pzJawpdNOcdbSp5Zv6se/0nznzImOZvR7US8F9cL94C5cLe8PbU72fNc@lists.postgresql.org X-Gm-Message-State: AOJu0YwNZ0qi1KdvEzl0MT0uyzDj4T7q/58Dq18cSepEbkiuQrnBbF2I dAZpFpRQOhagBBHa0k0QUTPurmGA3NEraghnbTX3myS6OBK/fxNnKmLYao4SOgD+KvuAykOWgMP IAg4l8OP30h22QJJZFEz4NOY615Xk8ME= X-Gm-Gg: ASbGncsVKxqikfl15KuGlnlh/TKU5wGT07EL7W0NCdoiCwX9IyRFns0q9R746hM4KKZ Gb4iN4BJlONmxE5aCES5cVnfCoS+lbda6S/0j+Y12d3xtrwgKYxouiXNUMjbl2TrvagcfTPMOlB tZFzBirGJyAMrKcAEir1C3sKjjrTEohHhLARelMkM3fXzjphDnBNQYzhFQaM+3RSuuhxUp4FzMp E2pat/r X-Google-Smtp-Source: AGHT+IGMlgepdhfYEZR5E4uvCi9GYX8SbDT8szdQtxQOMw2A+wfLyCev/8xAbkv++pbJYFES6BW70whVlk/D+tYsfnU= X-Received: by 2002:a05:6830:2aa1:b0:74a:9c6c:1882 with SMTP id 46e09a7af769-7a0543c551amr317638a34.28.1758732695215; Wed, 24 Sep 2025 09:51:35 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:361b:b0:5f3:5bf6:6b0b with HTTP; Wed, 24 Sep 2025 09:51:34 -0700 (PDT) In-Reply-To: <8f2e4644-eccd-49e8-b70b-b5c51c3aaa8c@aklaver.com> References: <8f2e4644-eccd-49e8-b70b-b5c51c3aaa8c@aklaver.com> From: "David G. Johnston" Date: Wed, 24 Sep 2025 10:51:34 -0600 X-Gm-Features: AS18NWC3n8VJR__fl1g3QwvMneWs3Y-7wDTi5eMOaUI6Oxz7EvS3uWWzKCCNpJY Message-ID: Subject: Re: How do I upsert depending on a second table? To: Adrian Klaver Cc: Juan Rodrigo Alejandro Burgos Mella , Samuel Marks , pgsql-general Content-Type: multipart/alternative; boundary="0000000000008da4a1063f8edd8c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008da4a1063f8edd8c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable This thread is annoyingly full of replies that do not follow the established conventions for making threads like this readable online and in the archive. Please: 1. Avoid top-posting and instead include your replies inline (or, at worse, at the end) 2. Remove content not relevant to your immediate reply. 3. After you=E2=80=99ve made your last inline comment REMOVE all subsequent content. This is just a special case of point 2 but this last message makes it extremely obvious just how obnoxious leaving trailing off-topic content is. David J. --0000000000008da4a1063f8edd8c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable This thread is annoyingly full of replies that do not follow the establishe= d conventions for making threads like this readable online and in the archi= ve.

Please:
1. Avoid top-posting and instead i= nclude your replies inline (or, at worse, at the end)
2. Remove c= ontent not relevant to your immediate reply.
3. After you=E2=80= =99ve made your last inline comment REMOVE all subsequent content.=C2=A0 Th= is is just a special case of point 2 but this last message makes it extreme= ly obvious just how obnoxious leaving trailing off-topic content is.
<= div>

David J.

--0000000000008da4a1063f8edd8c--