On 03/14/2017 09:00 AM, Alexander Farber wrote:
My initial idea has been not to use ON CONFLICT at all, but instead only UPDATE the words_reviews records (set "uid" or "author" to out_uid) for which NO EXISTS already such a record with PK (uid, author)... and then
I am afraid the logic is escaping me. If the record does not exist how can you UPDATE it?
DELETE the rest (as I can't update them without a conflict) but I haven't figured it out yet... Thank you anyway
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
