/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 362 insert into excluded values(1, '1'); 364 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 370 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 373 drop table excluded; 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 [all …]
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 362 insert into excluded values(1, '1'); 364 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 370 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 373 drop table excluded; 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 [all …]
|
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 362 insert into excluded values(1, '1'); 364 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 370 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 373 drop table excluded; 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 [all …]
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 362 insert into excluded values(1, '1'); 364 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 370 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 373 drop table excluded; 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 [all …]
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 362 insert into excluded values(1, '1'); 364 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 370 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 373 drop table excluded; 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 [all …]
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 362 insert into excluded values(1, '1'); 364 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 370 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 373 drop table excluded; 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 [all …]
|
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 362 insert into excluded values(1, '1'); 364 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 370 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 373 drop table excluded; 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 [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | insert_conflict.sql | 251 (fruit, key) = (excluded.fruit, excluded.key); 261 excluded.fruit; 833 population = excluded.population, altitude = excluded.altitude; 866 population = excluded.population, altitude = excluded.altitude; 885 INSERT INTO excluded 889 INSERT INTO excluded 916 INSERT INTO excluded 922 excluded.*; 925 DROP TABLE excluded; 944 … drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql12-plpython/postgresql-12.9/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|
/dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/ |
H A D | insert_conflict.sql | 98 on conflict (key) do update set (fruit, key) = (excluded.fruit, excluded.key); 233 where i.* != excluded.* returning *; 239 where i.* = excluded.* returning *; 361 insert into excluded values(1, '1'); 363 insert into excluded values(1, '2') on conflict (key) do update set data = excluded.data RETURNING … 369 insert into excluded values(1, '2') on conflict (key) do update set data = 3 RETURNING excluded.*; 372 drop table excluded; 380 …do update set drop1 = excluded.drop1, keep1 = excluded.keep1, drop2 = excluded.drop2, keep2 = excl… 381 …where excluded.drop1 is not null and excluded.keep1 is not null and excluded.drop2 is not null and… 393 do update set keep1 = excluded.keep1, keep2 = excluded.keep2 [all …]
|