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 1savyK-00CJnN-Hk for pgsql-general@arkaria.postgresql.org; Mon, 05 Aug 2024 11:33:52 +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 1savyJ-00CzCx-2E for pgsql-general@arkaria.postgresql.org; Mon, 05 Aug 2024 11:33:51 +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 1savyI-00CzCp-NR for pgsql-general@lists.postgresql.org; Mon, 05 Aug 2024 11:33:50 +0000 Received: from mail-oa1-x2d.google.com ([2001:4860:4864:20::2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1savyG-003D18-3q for pgsql-general@lists.postgresql.org; Mon, 05 Aug 2024 11:33:49 +0000 Received: by mail-oa1-x2d.google.com with SMTP id 586e51a60fabf-2681941eae0so3673042fac.0 for ; Mon, 05 Aug 2024 04:33:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1722857627; x=1723462427; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=LCIAK8HUlMpjDhaZi/ysaTwstQEgY9wlJBGFwpQRQqs=; b=DDcTpESCTqlpuw/w161WPweBh/nJXUxDIdkBObBLyt6RdE68sT7pxDT9pYtzZh7crz lg1EVAgzC/83E57W5IX3kRIC7MJ/8t/Gf29FkM/H8PiNbr9j0qGTfxCaZRSxrOfy8B+q uh5mczKc42n0Oq27Q98o/w4+xkhZjJ4qrl3mg478zDbXoalPZ4kdLftuQcmaQ+1ZvWQ+ JTAFquZVw9PkMpjCmYuLLKSE+aPVuy4mELj7nJLBJBldznqxJdH7EC6mvUSSk4GL+OKj +OQrbtGNWpPR0T0Q2gvDQr9A6vYnzHEmIRlM/JbdyQhoAAMe2C5b5yt+Iz1dqAaTPCkK k87Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1722857627; x=1723462427; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=LCIAK8HUlMpjDhaZi/ysaTwstQEgY9wlJBGFwpQRQqs=; b=kLkSLVv1TaxoQ5qj5tGgLRDYk1pR9SleEgv6GeS2jGkzxMy58u2LhhrMGIX6fdF0wm BBdqUTk7HvVZKJP7qASsgeWylFEw8e2ZEzHe/Zagzf1wj8FrAFaijiwB/J2HVDzI368L KvImSv9k9pGo0eA9/wfM8ABSxxh2s5i8aau/ev8fEZpla2O4709tPo4JlgPx2hstPxha DlYjfdZdLXonON1LAM8dBpwN7yzhciuIpH3vV4wQje9aCwL+40gaUcgt4x9ercEAxBcK DOMBeUGnig5Os4pZ34PaC6IZu6quuXPW5kkiSsPSv6kkEWXIGk+ts8qmQEo8riXboLgZ qElg== X-Gm-Message-State: AOJu0Yyjq9i518gkDv28EyeNCR6zeIY66OX+0ChkTNFPHRvybm2YyI0W WVC2mr771QRjegBQUP9IQkYh40werXrxfb3iqPluWLoinSsgqFs/R1wIu+HVjnbR/URUnLc2CJY KOra5w4PAn8vosVmf1qqkvQo+qoBjddxe X-Google-Smtp-Source: AGHT+IFs0Wbyz6/MjG+NaqaIy4UOiW2VFLzfOftKMDedzP4ptqJrFZXm2iJcmXis0/ngaDwQtgJXXjjdHXEszkHXYXs= X-Received: by 2002:a05:6870:7181:b0:260:3ae9:c94 with SMTP id 586e51a60fabf-26891f5741cmr9101267fac.51.1722857627373; Mon, 05 Aug 2024 04:33:47 -0700 (PDT) MIME-Version: 1.0 From: Dominique Devienne Date: Mon, 5 Aug 2024 13:33:36 +0200 Message-ID: Subject: UPDATE-FROM and INNER-JOIN To: pgsql-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk In https://sqlite.org/forum/forumpost/df23d80682 Richard Hipp (Mr SQLite) shows an example of something that used to be supported by SQLite, but then wasn't, to be compatible with PostgreSQL. Thus I'm curious as to why PostgreSQL refuses the first formulation. Could anyone provide any insights? Thanks, --DD