Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: BUG #19516: Mixup of OLD/NEW with RETURNING when parenthesized
To: pgsql-bugs@lists.postgresql.org
From: PG Bug reporting form <noreply@postgresql.org>
Cc: markoog@gmail.com
Reply-To: markoog@gmail.com, pgsql-bugs@lists.postgresql.org
Date: Wed, 10 Jun 2026 10:09:51 +0000
Message-ID: <19516-97e045ee5e78c98d@postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/19516-97e045ee5e78c98d%40postgresql.org>
Precedence: bulk

The following bug has been logged on the website:

Bug reference:      19516
Logged by:          Marko Grujic
Email address:      markoog@gmail.com
PostgreSQL version: 18.4
Operating system:   MacOS, Debian
Description:       =20

Hi, reporting a basic bug which involves a RETURNING clause on DML with
parenthesized OLD/NEW.

Effectively, the (parenthesized) row reference isn't being honored, and
instead the default behavior is applied.

Seeing this on tip of master as well (19beta1).

postgres=3D# create table t(a int, b text);
CREATE TABLE
postgres=3D# insert into t values (1, 'one') returning (old).b, old.b,
(new).b, new.b;
  b  | b |  b  |  b
-----+---+-----+-----
 one |   | one | one
(1 row)

INSERT 0 1
postgres=3D# update t set b =3D '1' where a =3D 1 returning (old).b, old.b,
(new).b, new.b;
 b |  b  | b | b
---+-----+---+---
 1 | one | 1 | 1
(1 row)

UPDATE 1
postgres=3D# delete from t where a =3D 1 returning (old).b, old.b, (new).b,
new.b;
 b | b | b | b
---+---+---+---
 1 | 1 | 1 |
(1 row)

DELETE 1
postgres=3D# select version();
                                                      version
---------------------------------------------------------------------------=
-----------------------------------------
 PostgreSQL 18.4 (Debian 18.4-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled
by gcc (Debian 14.2.0-19) 14.2.0, 64-bit
(1 row)