/dports/databases/postgresql96-server/postgresql-9.6.24/contrib/postgres_fdw/sql/ |
H A D | postgres_fdw.sql | 299 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 D | postgres_fdw.sql | 299 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 D | postgres_fdw.sql | 299 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 D | postgres_fdw.sql | 299 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 D | postgres_fdw.sql | 299 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 D | postgres_fdw.sql | 299 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 D | postgres_fdw.sql | 299 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 | .gitignore | 13 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 D | postgres_fdw.sql | 307 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 D | postgres_fdw.sql | 307 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 D | postgres_fdw.sql | 307 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 D | postgres_fdw.sql | 307 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 D | postgres_fdw.sql | 307 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 D | postgres_fdw.sql | 307 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 D | postgres_fdw.sql | 307 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 D | postgres_fdw.sql | 310 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 D | postgres_fdw.sql | 310 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 D | postgres_fdw.sql | 335 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 D | postgres_fdw.sql | 335 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 D | postgres_fdw.sql | 310 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 D | postgres_fdw.sql | 335 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 D | postgres_fdw.sql | 335 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 D | postgres_fdw.sql | 335 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 D | postgres_fdw.sql | 310 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 D | postgres_fdw.sql | 310 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 …]
|