Home
last modified time | relevance | path

Searched refs:ft2 (Results 1 – 25 of 1689) sorted by relevance

12345678910>>...68

/dports/databases/postgresql96-server/postgresql-9.6.24/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql299 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
303 SELECT * FROM ft2 a, ft2 b
305 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 ORDER BY ft2.c1, random();
315 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
550 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
708 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
769 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
771 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql299 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
303 SELECT * FROM ft2 a, ft2 b
305 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 ORDER BY ft2.c1, random();
315 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
550 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
708 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
769 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
771 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql96-plpython/postgresql-9.6.24/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql299 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
303 SELECT * FROM ft2 a, ft2 b
305 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 ORDER BY ft2.c1, random();
315 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
550 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
708 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
769 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
771 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql96-client/postgresql-9.6.24/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql299 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
303 SELECT * FROM ft2 a, ft2 b
305 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 ORDER BY ft2.c1, random();
315 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
550 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
708 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
769 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
771 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql96-plperl/postgresql-9.6.24/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql299 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
303 SELECT * FROM ft2 a, ft2 b
305 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 ORDER BY ft2.c1, random();
315 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
550 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
708 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
769 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
771 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql96-contrib/postgresql-9.6.24/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql299 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
303 SELECT * FROM ft2 a, ft2 b
305 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 ORDER BY ft2.c1, random();
315 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
550 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
708 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
769 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
771 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql96-docs/postgresql-9.6.24/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql299 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
303 SELECT * FROM ft2 a, ft2 b
305 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 ORDER BY ft2.c1, random();
315 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
550 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
708 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
769 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
771 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/audio/fasttracker2/ft2-clone-1.49/
H A D.gitignore13 vs2019_project/.vs/ft2-clone/v16/.suo
16 vs2019_project/ft2-clone/Release/ft2-clone.vcxproj.FileListAbsolute.txt
17 vs2019_project/ft2-clone/x64/Debug/ft2-clone.vcxproj.FileListAbsolute.txt
19 vs2019_project/ft2-clone/Debug/ft2-clone.vcxproj.FileListAbsolute.txt
24 vs2019_project/ft2-clone/Release/ft2-clone-win64.iobj
25 vs2019_project/ft2-clone/Release/ft2-clone-win32.iobj
/dports/databases/postgresql10-plperl/postgresql-10.19/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql307 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
311 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 a, ft2 b
321 SELECT * FROM ft2 ORDER BY ft2.c1, random();
323 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
548 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
1061 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
1123 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1125 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql10-server/postgresql-10.19/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql307 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
311 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 a, ft2 b
321 SELECT * FROM ft2 ORDER BY ft2.c1, random();
323 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
548 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
1061 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
1123 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1125 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql10-client/postgresql-10.19/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql307 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
311 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 a, ft2 b
321 SELECT * FROM ft2 ORDER BY ft2.c1, random();
323 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
548 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
1061 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
1123 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1125 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql10-docs/postgresql-10.19/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql307 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
311 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 a, ft2 b
321 SELECT * FROM ft2 ORDER BY ft2.c1, random();
323 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
548 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
1061 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
1123 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1125 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql10-pltcl/postgresql-10.19/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql307 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
311 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 a, ft2 b
321 SELECT * FROM ft2 ORDER BY ft2.c1, random();
323 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
548 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
1061 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
1123 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1125 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql10-plpython/postgresql-10.19/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql307 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
311 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 a, ft2 b
321 SELECT * FROM ft2 ORDER BY ft2.c1, random();
323 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
548 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
1061 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
1123 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1125 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql10-contrib/postgresql-10.19/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql307 SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2;
311 SELECT * FROM ft2 a, ft2 b
313 SELECT * FROM ft2 a, ft2 b
321 SELECT * FROM ft2 ORDER BY ft2.c1, random();
323 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
548 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
549 SELECT q.a, ft2.c1 FROM (SELECT 13 FROM ft1 WHERE c1 = 13) q(a) RIGHT JOIN ft2 ON (q.a = ft2.c1) WH…
1061 SELECT ftx.x1, ft2.c2, ftx FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8), ft2
1123 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1125 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
[all …]
/dports/databases/postgresql12-contrib/postgresql-12.9/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql310 SELECT * FROM ft2 a, ft2 b
312 SELECT * FROM ft2 a, ft2 b
322 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
1140 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1172 RETURNING ft2, ft2.*, ft4, ft4.*;
1176 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1180 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1182 DELETE FROM ft2 WHERE ft2.c1 > 1200;
1225 RETURNING ft2.c1, ft2.c2, ft2.c3; -- can't be pushed down
1229 RETURNING ft2.c1, ft2.c2, ft2.c3;
[all …]
/dports/databases/postgresql12-client/postgresql-12.9/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql310 SELECT * FROM ft2 a, ft2 b
312 SELECT * FROM ft2 a, ft2 b
322 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
1140 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1172 RETURNING ft2, ft2.*, ft4, ft4.*;
1176 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1180 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1182 DELETE FROM ft2 WHERE ft2.c1 > 1200;
1225 RETURNING ft2.c1, ft2.c2, ft2.c3; -- can't be pushed down
1229 RETURNING ft2.c1, ft2.c2, ft2.c3;
[all …]
/dports/databases/postgresql13-server/postgresql-13.5/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql335 SELECT * FROM ft2 a, ft2 b
337 SELECT * FROM ft2 a, ft2 b
347 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
1165 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1197 RETURNING ft2, ft2.*, ft4, ft4.*;
1201 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1205 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1207 DELETE FROM ft2 WHERE ft2.c1 > 1200;
1250 RETURNING ft2.c1, ft2.c2, ft2.c3; -- can't be pushed down
1254 RETURNING ft2.c1, ft2.c2, ft2.c3;
[all …]
/dports/databases/postgresql13-pltcl/postgresql-13.5/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql335 SELECT * FROM ft2 a, ft2 b
337 SELECT * FROM ft2 a, ft2 b
347 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
1165 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1197 RETURNING ft2, ft2.*, ft4, ft4.*;
1201 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1205 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1207 DELETE FROM ft2 WHERE ft2.c1 > 1200;
1250 RETURNING ft2.c1, ft2.c2, ft2.c3; -- can't be pushed down
1254 RETURNING ft2.c1, ft2.c2, ft2.c3;
[all …]
/dports/databases/postgresql12-plperl/postgresql-12.9/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql310 SELECT * FROM ft2 a, ft2 b
312 SELECT * FROM ft2 a, ft2 b
322 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
1140 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1172 RETURNING ft2, ft2.*, ft4, ft4.*;
1176 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1180 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1182 DELETE FROM ft2 WHERE ft2.c1 > 1200;
1225 RETURNING ft2.c1, ft2.c2, ft2.c3; -- can't be pushed down
1229 RETURNING ft2.c1, ft2.c2, ft2.c3;
[all …]
/dports/databases/postgresql13-docs/postgresql-13.5/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql335 SELECT * FROM ft2 a, ft2 b
337 SELECT * FROM ft2 a, ft2 b
347 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
1165 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1197 RETURNING ft2, ft2.*, ft4, ft4.*;
1201 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1205 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1207 DELETE FROM ft2 WHERE ft2.c1 > 1200;
1250 RETURNING ft2.c1, ft2.c2, ft2.c3; -- can't be pushed down
1254 RETURNING ft2.c1, ft2.c2, ft2.c3;
[all …]
/dports/databases/postgresql13-client/postgresql-13.5/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql335 SELECT * FROM ft2 a, ft2 b
337 SELECT * FROM ft2 a, ft2 b
347 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
1165 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1197 RETURNING ft2, ft2.*, ft4, ft4.*;
1201 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1205 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1207 DELETE FROM ft2 WHERE ft2.c1 > 1200;
1250 RETURNING ft2.c1, ft2.c2, ft2.c3; -- can't be pushed down
1254 RETURNING ft2.c1, ft2.c2, ft2.c3;
[all …]
/dports/databases/postgresql13-contrib/postgresql-13.5/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql335 SELECT * FROM ft2 a, ft2 b
337 SELECT * FROM ft2 a, ft2 b
347 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
1165 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1197 RETURNING ft2, ft2.*, ft4, ft4.*;
1201 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1205 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1207 DELETE FROM ft2 WHERE ft2.c1 > 1200;
1250 RETURNING ft2.c1, ft2.c2, ft2.c3; -- can't be pushed down
1254 RETURNING ft2.c1, ft2.c2, ft2.c3;
[all …]
/dports/databases/postgresql12-plpython/postgresql-12.9/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql310 SELECT * FROM ft2 a, ft2 b
312 SELECT * FROM ft2 a, ft2 b
322 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
1140 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1172 RETURNING ft2, ft2.*, ft4, ft4.*;
1176 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1180 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1182 DELETE FROM ft2 WHERE ft2.c1 > 1200;
1225 RETURNING ft2.c1, ft2.c2, ft2.c3; -- can't be pushed down
1229 RETURNING ft2.c1, ft2.c2, ft2.c3;
[all …]
/dports/databases/postgresql12-pltcl/postgresql-12.9/contrib/postgres_fdw/sql/
H A Dpostgres_fdw.sql310 SELECT * FROM ft2 a, ft2 b
312 SELECT * FROM ft2 a, ft2 b
322 SELECT * FROM ft2 ORDER BY ft2.c1, ft2.c3 collate "C";
1140 UPDATE ft2 SET c2 = ft2.c2 + 500, c3 = ft2.c3 || '_update9', c7 = DEFAULT
1172 RETURNING ft2, ft2.*, ft4, ft4.*;
1176 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1180 WHERE ft2.c1 > 1200 AND ft2.c1 % 10 = 0 AND ft2.c2 = ft4.c1
1182 DELETE FROM ft2 WHERE ft2.c1 > 1200;
1225 RETURNING ft2.c1, ft2.c2, ft2.c3; -- can't be pushed down
1229 RETURNING ft2.c1, ft2.c2, ft2.c3;
[all …]

12345678910>>...68