From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | Shaozhong SHI <shishaozhong(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Merge into does not work |
Date: | 2021-11-26 20:51:00 |
Message-ID: | 33716356-dcf4-41fa-d053-058997bb652b@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/26/21 12:10, Alvaro Herrera wrote:
> On 2021-Nov-26, Adrian Klaver wrote:
>
>> On 11/26/21 11:44, Alvaro Herrera wrote:
>>> On 2021-Nov-26, Shaozhong SHI wrote:
>>>
>>> I am using the MERGE patch I posted here[1], on top of Postgres 15.
>>>
>>> https://postgr.es/m/202111152245.byerxxac444d@alvherre.pgsql
>>
>> A patch that as AFAIK is not even committed to what is at best an alpha
>> version would in my opinion not qualify as ready much less supported. I look
>> forward to seeing it make it in, but I would hardly recommend it for general
>> use.
>
> All true. I'm recruiting testers.
Which is great, that was not how it was presented though:
'It does work for me ...'
The issue being there are already folks that come across:
https://wiki.postgresql.org/wiki/SQL_MERGE
https://wiki.postgresql.org/wiki/SQL_MERGE_Patch_Status
and do a partial read on the pages and leap to the conclusion the MERGE
exists in Postgres.
I fully expect people to see:
"
It does work for me:
55479 15devel 680346=# MERGE INTO Stock USING Buy ON Stock.item_id =
Buy.item_id
WHEN MATCHED THEN UPDATE SET balance = balance + Buy.volume
WHEN NOT MATCHED THEN INSERT VALUES (Buy.item_id, Buy.volume);
MERGE 2
Duración: 3,879 ms
55479 15devel 680346=# select * from stock;
item_id │ balance
─────────┼─────────
20 │ 1900
10 │ 3200
30 │ 300
(3 filas)
"
quit reading and then ask why MERGE does not exist in their instance?
My two cents worth.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Blake McBride | 2021-11-27 18:52:01 | Packaging pgAdmin 4 |
Previous Message | Alvaro Herrera | 2021-11-26 20:10:39 | Re: Merge into does not work |