On Wed, Oct 8, 2014 at 12:12 PM, Peter Geoghegan <p...@heroku.com> wrote: > On Mon, Sep 29, 2014 at 7:21 AM, Simon Riggs <si...@2ndquadrant.com> wrote: >> Having said that, it would be much nicer to have a mode that allows >> you to just say the word "UPDATE" and have it copy the data into the >> correct columns, like MySQL does. That is very intuitive, even if it >> isn't very flexible. > > I thought about this, and at first I agreed, but now I'm not so sure.
Actually, I don't think MySQL supports this. It doesn't allow INSERT ON DUPLICATE KEY UPDATE to do it, AFAICT. Their REPLACE syntax supports that, but that's a feature that is quite distinct to what I have in mind here. -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers