Re: UPDATE ... ON CONFLICT DO NOTHING

[Alexander Farber <alexander.farber@xxxxxxxxx>]

Yasin, thank you for this suggestion, but -

On Tue, Mar 14, 2017 at 12:07 PM, Yasin Sari <yasinsari81@xxxxxxxxxxxxxx> wrote:

​​

Have you tried with inner block and do nothing on exception;

 

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

   

but it seems to me that my method of INSERTing copies would be faster than the 2 loops