Home
last modified time | relevance | path

Searched refs:excluded (Results 1 – 25 of 9428) sorted by relevance

12345678910>>...378

/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql251 (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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 Dinsert_conflict.sql98 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 …]

12345678910>>...378