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.98.2) (envelope-from ) id 1xDk4d-00000000gFt-2JZ4 for pgsql-general@arkaria.postgresql.org; Mon, 05 Oct 2026 14:53:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xDk4c-0000000BJ8J-1fx5 for pgsql-general@arkaria.postgresql.org; Mon, 05 Oct 2026 14:53:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xDk4b-0000000BJ8A-1mJ9 for pgsql-general@lists.postgresql.org; Mon, 05 Oct 2026 14:53:50 +0000 Received: from fout-b4-smtp.messagingengine.com ([202.12.124.147]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xDk4Y-00000000Xv2-1I71 for pgsql-general@lists.postgresql.org; Mon, 05 Oct 2026 14:53:49 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfout.stl.internal (Postfix) with ESMTP id 20F451D000E8 for ; Mon, 5 Oct 2026 10:53:44 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Mon, 05 Oct 2026 10:53:44 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1791212023; x=1791298423; bh=JJ0dXozFf57DUFhUHeoNdzsvqLkOMfOmzTdHcHyHEoY=; b= dj7aCUEqaK5v9rKwugfqnupxMdXQsyTUUFjS68XWAnwxSmm8qtjEekDv7aVy9PMe lE8x7wu/N1xy7Yc2eeTuPHuK96ZGz0uhvlX5e8GVpYKMIxtDPoPdKzL28aTY9VEb 5Y0Ye1nRnbYI85YLPuUmuRqJoHOTZwQH3foMTJ4MNJMaHxmyDropYl6iZHYO/S7Y GDxdkllJJaYgJuZT8fhU5FkUP6KCaoNd1oxApaIDvOLvc2SNGUkFCrzyGRNPdM4d /xoGD4dQk86s5wOePfYg9bW5eB92pKyhpKDk2Q2dw0rrj+xexxWBH7s7RvPP2zYd 2ysNEoTRkuDOg3MsrvbrCQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1791212023; x= 1791298423; bh=JJ0dXozFf57DUFhUHeoNdzsvqLkOMfOmzTdHcHyHEoY=; b=m Q7/RfOdy3+O+YnqQ29yfZWa9iUObd/C+x/lklvKxFBbuCl69kSJ3HMOfhk4DJ7EY /PGCwi9RYKNQq+m3LgExGk2Lg42c/6ggROkMYM4x1b7YKjabGY7MLBRzOfD11OuV rAwt4LLZEAQn/NK0l68+XAdElJOEr1IJav+V6ePZxEaYeKjmXNvrxONTfbyRfk1N 5iYzw2/XfkwbAtc4mnMz1nJE35Ku2JMpqPDqT7Gf5U3WtnKT9LRqxqS70XywkTBf gYSri4sTqWu9tWkxwspkYp8Uy4rPLVrYFziwDP3z6vEdKgiii/HUcsaah24M3Zsj pcqLcUVdHjRwz9XFeMdfg== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-09-30; sw=lmtpprox; action=sign d=aklaver.com a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1791212023; d=aklaver.com; mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+; rt=PHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm1:rsa-sha256:a7/jlY//NA6k3yjqMJe38qpDCl1J38Rs81I28ZV9Z0fSvhx 7QarEG5Od/phgf6NLBzgz/mvSaMiQGTzoARQrRUj1Om+dmm6z4KyGwnVZfzKS4jG VNCcDSTINM3YMpYIBvNgx0rh7j9FFUguLwjwhYJR1bMxMI3wx92hOEch/5mH+kYr Vhqdz8JCloTm2l4sX6FdA45xDpD9THGSUZn/ED2++ZtEXKXSdDE69nRKP/49Ec2C obIxYuFCnm0AiXdA7dApKN/nKsRmtbZGG36JVUK54e/OmBB8Km0BQOga6f2+B8Tj tw7mkiiSsmxnsqTR7qaNvR3SKWcM6eFVQ3+crRw==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-09-30; sw=lmtpprox; action=mi-m=1; hc=14; hn=cc,content-language,content-transfer-encoding,content-type, date,feedback-id,from,in-reply-to,message-id,mime-version, references,subject,to,user-agent; Message-Instance: m=1; h=sha256:1dtkppeq6rgtV67S6T56C6kFzbaXDPlfLxxjxHE+uRs=:zda3HvQ/X18go8Ij7nWa3y7mEzvaTqeSXTwShE4Wv8k=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTGj/fJyhMmAm56z8ZEo84jqr+vC/0/T5icHEvLAyN7fQpAQJMFNeCjCPraDGEYpYA uTIO6ZJDCz98KK7ByRlwXpzZsFHWm1/0wh1ZdcEpiq/wj8tmbOap5VUdB25FVSbkxjJxCG Rn2vDTmgbGxaq49njYvwXCKrj6XIfFARG/6gj5ugq4K/TcWkBj91WfhPcUbYErkurztyvH /DtQjKEswUOfJ2FbLk5BZmmqT+xc+AzxPIX94lQvixfhT2qbux3c4aDkFGohvMRjU+n7ma /u8iQmoUfVbC2GjznYq9uASmpiycIOXOF+a0Ca1bMR5wH1t7zdcMIyGvSvj80qLDKItYR2 CqmVRMaCwgt7WJbMV0UteVXrwqyEV9917wrqSSdqJCY8DR6rTAhEaafpdcVL/CkfKtp8aw 3H3tNxir561EPa0RigqNRbuVukpM6jbcmi+cnTNOLBvo2ZPzYkq81cfb1J0svAYDmELoR/ qSVcGszkVnRxwwyUnmNUh78tKjgzoE5owrnQ1h8S1HAYW8C0GO0FGSYpbv03mY3sG/+F/J FyltX7ds8poa7YXiwgl1H2HNvoOQXsRyMbaU+WoCjnvrO4uFH0H3qv7uPCQ6U9HTFatovm OT0RUab2yPZXp0wYHUVNewsJ1lqnS3n4P8pzwf9YbJexB1F+S4SrwHEskG7w X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 5 Oct 2026 10:53:42 -0400 (EDT) Message-ID: Date: Mon, 5 Oct 2026 07:53:41 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: bug or feature To: "David G. Johnston" , "Carl.Weierstrass" Cc: "pgsql-general@lists.postgresql.org" References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/5/26 7:32 AM, David G. Johnston wrote: > On Monday, October 5, 2026, Carl.Weierstrass > > wrote: > > but the more elegant version in one single statement results in a > syntax error > > begin; > insert into test2 > delete from test1 > where 1 = 1 > returning *;  --return deleted lines > commit; > > psql:test.sql:32: FEHLER:  Syntaxfehler bei »delete« > ZEILE 2: delete from test1 > > Is this a bug or a feature? > > > If you make something up that isn’t documented it shouldn’t work.  You > can call the inability to interpret random stuff you send to the server > a feature if you need an apply a label. > > You might want to look at the WITH clause of those commands to see how > to go about combining multiple distinct commands into one execution > correctly. In particular: https://www.postgresql.org/docs/current/queries-with.html#QUERIES-WITH-MODIFYING > > David J. > -- Adrian Klaver adrian.klaver@aklaver.com