regress/sql/insert_conflict.sql

23 …rtconflicttest values(0, 'Crowberry') on conflict (key, fruit) do update set fruit = excluded.fruit
24   where exists (select 1 from insertconflicttest ii where ii.key = excluded.key);
80 …o insertconflicttest values (0, 'Bilberry') on conflict (key) do update set fruit = excluded.fruit;
82 …licttest values (0, 'Bilberry') on conflict (key) do update set fruit = excluded.fruit where inser…
84 …alues(0, 'Crowberry') on conflict (key) do update set fruit = excluded.fruit where excluded.fruit …
86 …licttest values (0, 'Bilberry') on conflict (key) do update set fruit = excluded.fruit where inser…
89 insert into insertconflicttest values (1, 'Apple') on conflict do update set fruit = excluded.fruit;
92 insert into insertconflicttest values (1, 'Apple') on conflict (key) do update set fruit = excluded…
93 …conflicttest values (2, 'Orange') on conflict (key, key, key) do update set fruit = excluded.fruit;
98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key);
102 …values (1, 'Apple') on conflict (key) do update set fruit = excluded.fruit RETURNING excluded.frui…
105 …nto insertconflicttest values (1, 'Apple') on conflict (keyy) do update set fruit = excluded.fruit;
108 insert into insertconflicttest values (1, 'Apple') on conflict (key) do update set fruit = excluded…
111 …nsertconflicttest values (3, 'Kiwi') on conflict (key, fruit) do update set fruit = excluded.fruit;
112 …sertconflicttest values (4, 'Mango') on conflict (fruit, key) do update set fruit = excluded.fruit;
113 …to insertconflicttest values (5, 'Lemon') on conflict (fruit) do update set fruit = excluded.fruit;
114 …icttest values (6, 'Passionfruit') on conflict (lower(fruit)) do update set fruit = excluded.fruit;
117 … ict values (6, 'Passionfruit') on conflict (key) do update set fruit = excluded.fruit; -- ok, no …
129 …conflicttest values (7, 'Raspberry') on conflict (key, fruit) do update set fruit = excluded.fruit;
130 …nsertconflicttest values (8, 'Lime') on conflict (fruit, key) do update set fruit = excluded.fruit;
133 …nto insertconflicttest values (9, 'Banana') on conflict (key) do update set fruit = excluded.fruit;
134 …licttest values (10, 'Blueberry') on conflict (key, key, key) do update set fruit = excluded.fruit;
135 …icttest values (11, 'Cherry') on conflict (key, lower(fruit)) do update set fruit = excluded.fruit;
136 …flicttest values (12, 'Date') on conflict (lower(fruit), key) do update set fruit = excluded.fruit;
147 …ertconflicttest values (13, 'Grape') on conflict (key, fruit) do update set fruit = excluded.fruit;
148 …rtconflicttest values (14, 'Raisin') on conflict (fruit, key) do update set fruit = excluded.fruit;
149 …insertconflicttest values (15, 'Cranberry') on conflict (key) do update set fruit = excluded.fruit;
150 …conflicttest values (16, 'Melon') on conflict (key, key, key) do update set fruit = excluded.fruit;
151 …ttest values (17, 'Mulberry') on conflict (key, lower(fruit)) do update set fruit = excluded.fruit;
152 …test values (18, 'Pineapple') on conflict (lower(fruit), key) do update set fruit = excluded.fruit;
163 …conflicttest values (20, 'Quince') on conflict (lower(fruit)) do update set fruit = excluded.fruit;
164 … (21, 'Pomegranate') on conflict (lower(fruit), lower(fruit)) do update set fruit = excluded.fruit;
167 …onflicttest values (22, 'Apricot') on conflict (upper(fruit)) do update set fruit = excluded.fruit;
168 …ertconflicttest values (23, 'Blackberry') on conflict (fruit) do update set fruit = excluded.fruit;
179 …flicttest values (24, 'Plum') on conflict (key, lower(fruit)) do update set fruit = excluded.fruit;
180 …licttest values (25, 'Peach') on conflict (lower(fruit), key) do update set fruit = excluded.fruit;
182 …26, 'Fig') on conflict (lower(fruit), key, lower(fruit), key) do update set fruit = excluded.fruit;
185 …licttest values (27, 'Prune') on conflict (key, upper(fruit)) do update set fruit = excluded.fruit;
186 …nflicttest values (28, 'Redcurrant') on conflict (fruit, key) do update set fruit = excluded.fruit;
187 …insertconflicttest values (29, 'Nectarine') on conflict (key) do update set fruit = excluded.fruit;
199 insert into insertconflicttest values (26, 'Fig') on conflict (key) do update set fruit = excluded.…
202 …nto insertconflicttest values (26, 'Peach') on conflict (key) do update set fruit = excluded.fruit;
205 …nto insertconflicttest values (25, 'Fig') on conflict (fruit) do update set fruit = excluded.fruit;
216 …23, 'Blackberry') on conflict (key) where fruit like '%berry' do update set fruit = excluded.fruit;
220 …nsertconflicttest values (23, 'Blackberry') on conflict (key) do update set fruit = excluded.fruit;
222 …, 'Blackberry') on conflict (fruit) where fruit like '%berry' do update set fruit = excluded.fruit;
232 …rtconflicttest as i values (23, 'Jackfruit') on conflict (key) do update set fruit = excluded.fruit
233   where i.* != excluded.* returning *;
235 …rtconflicttest as i values (23, 'Jackfruit') on conflict (key) do update set fruit = excluded.fruit
236   where i.* != excluded.* returning *;
238 …rtconflicttest as i values (23, 'Jackfruit') on conflict (key) do update set fruit = excluded.fruit
239   where i.* = excluded.* returning *;
241 …rtconflicttest as i values (23, 'Avocado') on conflict (key) do update set fruit = excluded.*::text
244 …alues (23, 'Avocado') on conflict (key) do update set fruit = excluded.fruit where excluded.* is n…
245 …tconflicttest as i values (23, 'Avocado') on conflict (key) do update set fruit = excluded.*::text;
260 insert into syscolconflicttest values (1) on conflict (key) do update set data = excluded.ctid::tex…
261 insert into syscolconflicttest values (1) on conflict (key) do update set data = excluded.oid::text;
295   on conflict (f1) do update set f2 = excluded.f2;
298   on conflict (f1) do update set f2 = excluded.f2;
339 …Sacramento', 4664.E+5, 30, 'CA') on conflict (name) do update set population = excluded.population;
343 …+5, 2001) on conflict (name) do update set population = excluded.population, altitude = excluded.a…
345 …Las Vegas', 5.83E+5, 2222, 'NV') on conflict (name) do update set population = excluded.population;
352 …+5, 2223) on conflict (name) do update set population = excluded.population, altitude = excluded.a…
361 create table excluded(key int primary key, data text);  table
362 insert into excluded values(1, '1');
364 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING …
366 insert into excluded AS target values(1, '2') on conflict (key) do update set data = excluded.data …
368 insert into excluded AS target values(1, '2') on conflict (key) do update set data = target.data RE…
370 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*;
373 drop table excluded;
379 insert into testoids values(1, '1') on conflict (key) do update set data = excluded.data RETURNING …
380 insert into testoids values(1, '2') on conflict (key) do update set data = excluded.data RETURNING …
384 insert into testoids values(1, '3') on conflict (key) do update set data = excluded.data RETURNING …
386 insert into testoids values(2, '1') on conflict (key) do update set data = excluded.data RETURNING …
388 insert into testoids values(2, '2') on conflict (key) do update set data = excluded.data RETURNING …
391 insert into testoids values(1, '4') on conflict (key) do update set data = excluded.data RETURNING …
392 insert into testoids values(3, '1') on conflict (key) do update set data = excluded.data RETURNING …
393 insert into testoids values(3, '2') on conflict (key) do update set data = excluded.data RETURNING …
403 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl…
404 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and…
416     do update set keep1 = excluded.keep1, keep2 = excluded.keep2
417     where excluded.keep1 is not null and excluded.keep2 is not null
484 insert into parted_conflict_test values (1, 'a') on conflict (a) do update set b = excluded.b;
488 insert into parted_conflict_test_1 values (1, 'b') on conflict (a) do update set b = excluded.b;
491 insert into parted_conflict_test values (2, 'b') on conflict (b) do update set a = excluded.a;
494 insert into parted_conflict_test_1 values (2, 'b') on conflict (b) do update set a = excluded.a;
504 insert into parted_conflict_test values (3, 'a') on conflict (a) do update set b = excluded.b;
505 insert into parted_conflict_test values (3, 'b') on conflict (a) do update set b = excluded.b;
514 insert into parted_conflict_test (a, b) values (4, 'a') on conflict (a) do update set b = excluded.…
515 insert into parted_conflict_test (a, b) values (4, 'b') on conflict (a) do update set b = excluded.…
524 insert into parted_conflict_test (a, b) values (5, 'a') on conflict (a) do update set b = excluded.…
525 insert into parted_conflict_test (a, b) values (5, 'b') on conflict (a) do update set b = excluded.…
532 …s (1, 'a'), (2, 'a'), (4, 'a') on conflict (a) do update set b = excluded.b where excluded.b = 'b';
533 …s (1, 'b'), (2, 'c'), (4, 'b') on conflict (a) do update set b = excluded.b where excluded.b = 'b';
547   on conflict (a) do update set b = excluded.b;
560   on conflict (a) do update set b = excluded.b;
572   on conflict (a, b) do update set (a, b, c) = row(excluded.*)
574         excluded = (50, text 'cincuenta', 2);