Yasin, thank you for this suggestion, but - On Tue, Mar 14, 2017 at 12:07 PM, Yasin Sari <yasinsar...@googlemail.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