| From: | Andreas Karlsson <andreas(at)proxel(dot)se> |
|---|---|
| To: | Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>, Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
| Subject: | Re: Proposal: INSERT ... BY NAME |
| Date: | 2026-07-10 08:52:36 |
| Message-ID: | c5090d60-09b3-4ca3-97cc-ddb99d87a301@proxel.se |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 7/10/26 10:06, Andreas Karlsson wrote:
> According the accepted change proposal which was discussed when I was
> there:
>
> INSERT INTO t (a,b) BY NAME SELECT 37 AS b, 42 AS a;
>
> is effectively the same thing as:
>
> INSERT INTO t (a,b) BY NAME SELECT a, b FROM (SELECT 37 AS b, 42 AS a);
Sorry, saw a minor typo in my example, it should have been:
INSERT INTO t (a,b) BY NAME SELECT 37 AS b, 42 AS a;
is effectively the same thing as:
INSERT INTO t (a,b) SELECT a, b FROM (SELECT 37 AS b, 42 AS a);
--
Andreas Karlsson
Percona
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Imran Zaheer | 2026-07-10 09:01:22 | Re: [WIP] Pipelined Recovery |
| Previous Message | Peter Eisentraut | 2026-07-10 08:42:29 | Re: [PATCH] Fix null pointer dereference in PG19 |