Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING
Дата
Msg-id 4b7f0c7d-7bd6-72a9-e776-f77e3c634d44@aklaver.com
обсуждение исходный текст
Ответ на Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING  (Alexander Farber <alexander.farber@gmail.com>)
Ответы Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING  (Alexander Farber <alexander.farber@gmail.com>)
Список pgsql-general
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@aklaver.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Maximum of connections in PG
Следующее
От: Yasin Sari
Дата:
Сообщение: Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING