Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] MERGE SQL Statement for PG11 - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: [HACKERS] MERGE SQL Statement for PG11
Date
Msg-id CAH2-WzneuBzYSn3ggs7JPAWDBDN8WYDSdwLjBrjL1RjW1+x9Vw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] MERGE SQL Statement for PG11  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On Tue, Mar 27, 2018 at 1:15 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> Accepted, the only question is whether it affects UPDATE as well cos
> it looks like it should.

If you mean an UPDATE FROM self-join, then I suppose that it does, in
a very limited way. The difference is that there are no hard-coded
assumptions about the relationship between those two RTEs.

-- 
Peter Geoghegan

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] path toward faster partition pruning
Next
From: Pavel Stehule
Date:
Subject: Re: Re: csv format for psql