diff options
Diffstat (limited to 'contrib/btree_gist/sql/not_equal.sql')
| -rw-r--r-- | contrib/btree_gist/sql/not_equal.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/btree_gist/sql/not_equal.sql b/contrib/btree_gist/sql/not_equal.sql index b1940ef4fe7..6dfac5d0aae 100644 --- a/contrib/btree_gist/sql/not_equal.sql +++ b/contrib/btree_gist/sql/not_equal.sql @@ -14,10 +14,14 @@ INSERT INTO test_ne VALUES('2007-02-03', -91.3); INSERT INTO test_ne VALUES('2011-09-01', 43.7); INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000); +SET enable_indexscan to false; + EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7; SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7; +RESET enable_indexscan; + -- test search for "not equals" using an exclusion constraint CREATE TABLE zoo ( |