Yasin, thank you for this suggestion, but -
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;
>>
>
>
>> 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