Re: UPDATE ... ON CONFLICT DO NOTHING

The convention on these lists is to inline or bottom-post.

On Tue, Mar 14, 2017 at 12:07 PM, Yasin Sari <yasinsari81(at)googlemail(dot)com>
wrote:

> ​​
> Have you tried with inner block and do nothing on exception;
>
>
​I suppose that would work - though using an exception path for expected
logic is messy - and considerably slower than detection.

After doing something like this the OP would then want to DELETE any
remaining records that still have the uid or author with the old value. Do
nothing by itself would just leave them alone.​

> BEGIN
>
> <your code>
> ..............
> BEGIN
>
> UPDATE words_social
> SET uid = out_uid
> WHERE uid = ANY(_uids);
>
> EXCEPTION WHEN OTHERS THEN
> --do nothing or write NULL means do nothing
>
>

​David J.​