| /dports/databases/postgresql96-server/postgresql-9.6.24/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql96-pltcl/postgresql-9.6.24/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql96-plpython/postgresql-9.6.24/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql10-docs/postgresql-10.19/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql10-client/postgresql-10.19/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql11-docs/postgresql-11.14/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql11-plperl/postgresql-11.14/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne (
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql11-plpython/postgresql-11.14/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql11-server/postgresql-11.14/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql10-server/postgresql-10.19/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql11-pltcl/postgresql-11.14/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne (
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql11-client/postgresql-11.14/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql12-contrib/postgresql-12.9/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql12-client/postgresql-12.9/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql14-server/postgresql-14.1/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql96-client/postgresql-9.6.24/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql14-plpython/postgresql-14.1/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql14-plperl/postgresql-14.1/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql14-pltcl/postgresql-14.1/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne ( table
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|
| /dports/databases/postgresql13-pltcl/postgresql-13.5/contrib/btree_gist/sql/ |
| H A D | not_equal.sql | 6 CREATE TABLE test_ne (
10 CREATE INDEX test_ne_idx ON test_ne USING gist (a, b);
12 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
13 INSERT INTO test_ne VALUES('2007-02-03', -91.3);
14 INSERT INTO test_ne VALUES('2011-09-01', 43.7);
15 INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
19 EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
21 SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
|