Skip to content

Instantly share code, notes, and snippets.

@woto
Created December 6, 2018 12:04
Show Gist options
  • Save woto/d5431edabb899a5698c90d21fd5ad139 to your computer and use it in GitHub Desktop.
Save woto/d5431edabb899a5698c90d21fd5ad139 to your computer and use it in GitHub Desktop.
gdeslon=# begin;
BEGIN
gdeslon=# UPDATE sales SET initiator = 'human' WHERE gs_order_id IN (4733101,4814060,5045578,2761356,3113259,3158908,5060756,3227701,4994584,3472936,4643596,4325613,5097799,4463556,4709183,5057299,5102945,3037175,3141875,3889107,4746201,4698855,3899259,4308014,4620971,3445374,4973622,3073276,4753219,4632260,4398456,5055112,5396304,5186646,5395751,5336857,5396205,3598535,4474090,5381409,5359223,5386413,5384849,3311271,5385151,5387127,5383425,5386496,5093853,5346721,5274973,4959252,4874160,5249273,5298124,5321132,3322202,4528250,4701741,4628222,5172108,5295830,5395261,5373196,5231922,5332825,5362603,5384270,4226945,5371464,5325283,5208760,3962696,5341750,5344433,5344938,4170788,4360691,4362785,4436840,4562022,3989914,5349389,5368872,5323842,5507156,5507155,5507134,5507158,5507159,5484752,5507132,5484754,5507161,5484753,5484751,5484757,5507157,5507162,5484756,5467484,5484755,5454971,5507154,5454930,5454944,5454985,5454976,5467487,5454945,5467483,5454936,5467486,5454973,5454961,5454964,5454984,5454974,5454977,5454968,5454975,5454962,5454969,5454970,5454981,5454986,5454932,5454946,5454980,5454966,5454933,5454967,5454934,5454943,5454978,5454982,5454928,5454927,5409513,5454935,5454931,5454983,5409506,5454965,5454963,5454929,5409505,5409501,5409517,5454972,5409503,5454979,5409507,5409512,5409523,5409502,5409510,5395131,5409522,5395137,5409509,5395136,5409518,5395140,5395138,5395134,5395139,5395130,5395135,5382723,5395132,5382725,5395133,5382722,5382729,5395141,5382720,5382719,5382736,5382728,5369375,5382734,5357888,5382718,5369379,5359323,5369380,5357875,5369381,5357884,5369376,5357886,5369378,5357874,5369377,5356805,5357887,5357885,5357873,5357876,5382724,5382730,5382727,5382726,5382721,5382735,5369125,5597061,4582321,5628473,5371064,5384894);
UPDATE 1433
gdeslon=# commit;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment