Search Postgresql Archives

Re: UPDATE ... ON CONFLICT DO NOTHING

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

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;


​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.​

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux