Advertisement
Guest User

Untitled

a guest
Apr 9th, 2020
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- район Искър, София
  2. update names
  3. set udf = jsonb_set(udf, '{district_id}', '"68134-14"')
  4. where alias = '07106'
  5.  
  6. -- район Витоша, София
  7. update names
  8. set udf = jsonb_set(udf, '{district_id}', '"68134-17"')
  9. where alias = '49597'
  10.  
  11. update names
  12. set udf = jsonb_set(udf, '{district_id}', '"68134-17"')
  13. where alias = '11394'
  14.  
  15. -- район Овча Купел, София
  16. update names
  17. set udf = jsonb_set(udf, '{district_id}', '"68134-18"')
  18. where alias = '46721'
  19.  
  20. -- район Връбница, София
  21. update names
  22. set udf = jsonb_set(udf, '{district_id}', '"68134-20"')
  23. where alias = '12084'
  24.  
  25. -- район Нови Искър, София
  26. update names
  27. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  28. where alias = '80409'
  29.  
  30. update names
  31. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  32. where alias = '65601'
  33.  
  34. update names
  35. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  36. where alias = '57011'
  37.  
  38. update names
  39. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  40. where alias = '00357'
  41.  
  42. update names
  43. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  44. where alias = '51250'
  45.  
  46. update names
  47. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  48. where alias = '49206'
  49.  
  50. update names
  51. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  52. where alias = '48393'
  53.  
  54. update names
  55. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  56. where alias = '44224'
  57.  
  58. update names
  59. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  60. where alias = '41010'
  61.  
  62. update names
  63. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  64. where alias = '40436'
  65.  
  66. update names
  67. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  68. where alias = '29430'
  69.  
  70. update names
  71. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  72. where alias = '21662'
  73.  
  74. update names
  75. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  76. where alias = '11884'
  77.  
  78. update names
  79. set udf = jsonb_set(udf, '{district_id}', '"68134-21"')
  80. where alias = '02511'
  81.  
  82. -- район Кремиковци, София
  83. update names
  84. set udf = jsonb_set(udf, '{district_id}', '"68134-22"')
  85. where alias = '87401'
  86.  
  87. update names
  88. set udf = jsonb_set(udf, '{district_id}', '"68134-22"')
  89. where alias = '29204'
  90.  
  91. update names
  92. set udf = jsonb_set(udf, '{district_id}', '"68134-22"')
  93. where alias = '22304'
  94.  
  95. update names
  96. set udf = jsonb_set(udf, '{district_id}', '"68134-22"')
  97. where alias = '16448'
  98.  
  99. update names
  100. set udf = jsonb_set(udf, '{district_id}', '"68134-22"')
  101. where alias = '07140'
  102.  
  103. -- район Панчарево, София
  104. update names
  105. set udf = jsonb_set(udf, '{district_id}', '"68134-23"')
  106. where alias = '56624'
  107.  
  108. update names
  109. set udf = jsonb_set(udf, '{district_id}', '"68134-23"')
  110. where alias = '55419'
  111.  
  112. update names
  113. set udf = jsonb_set(udf, '{district_id}', '"68134-23"')
  114. where alias = '44063'
  115.  
  116. update names
  117. set udf = jsonb_set(udf, '{district_id}', '"68134-23"')
  118. where alias = '39791'
  119.  
  120. update names
  121. set udf = jsonb_set(udf, '{district_id}', '"68134-23"')
  122. where alias = '37914'
  123.  
  124. update names
  125. set udf = jsonb_set(udf, '{district_id}', '"68134-23"')
  126. where alias = '35239'
  127.  
  128. update names
  129. set udf = jsonb_set(udf, '{district_id}', '"68134-23"')
  130. where alias = '29150'
  131.  
  132. update names
  133. set udf = jsonb_set(udf, '{district_id}', '"68134-23"')
  134. where alias = '22472'
  135.  
  136. update names
  137. set udf = jsonb_set(udf, '{district_id}', '"68134-23"')
  138. where alias = '14831'
  139.  
  140. update names
  141. set udf = jsonb_set(udf, '{district_id}', '"68134-23"')
  142. where alias = '04234'
  143.  
  144. -- район Панчарево, София
  145. update names
  146. set udf = jsonb_set(udf, '{district_id}', '"68134-24"')
  147. where alias = '37280'
  148.  
  149. update names
  150. set udf = jsonb_set(udf, '{district_id}', '"68134-24"')
  151. where alias = '32216'
  152.  
  153. update names
  154. set udf = jsonb_set(udf, '{district_id}', '"68134-24"')
  155. where alias = '02659'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement