summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/hash_index.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/hash_index.sql')
-rw-r--r--src/test/regress/sql/hash_index.sql16
1 files changed, 8 insertions, 8 deletions
diff --git a/src/test/regress/sql/hash_index.sql b/src/test/regress/sql/hash_index.sql
index cfd77d5720..b0811b7dc0 100644
--- a/src/test/regress/sql/hash_index.sql
+++ b/src/test/regress/sql/hash_index.sql
@@ -3,56 +3,56 @@
-- grep 843938989 hash.data
--
-SELECT hash_i4_heap.*
+SELECT * FROM hash_i4_heap
WHERE hash_i4_heap.random = 843938989;
--
-- hash index
-- grep 66766766 hash.data
--
-SELECT hash_i4_heap.*
+SELECT * FROM hash_i4_heap
WHERE hash_i4_heap.random = 66766766;
--
-- hash index
-- grep 1505703298 hash.data
--
-SELECT hash_name_heap.*
+SELECT * FROM hash_name_heap
WHERE hash_name_heap.random = '1505703298'::name;
--
-- hash index
-- grep 7777777 hash.data
--
-SELECT hash_name_heap.*
+SELECT * FROM hash_name_heap
WHERE hash_name_heap.random = '7777777'::name;
--
-- hash index
-- grep 1351610853 hash.data
--
-SELECT hash_txt_heap.*
+SELECT * FROM hash_txt_heap
WHERE hash_txt_heap.random = '1351610853'::text;
--
-- hash index
-- grep 111111112222222233333333 hash.data
--
-SELECT hash_txt_heap.*
+SELECT * FROM hash_txt_heap
WHERE hash_txt_heap.random = '111111112222222233333333'::text;
--
-- hash index
-- grep 444705537 hash.data
--
-SELECT hash_f8_heap.*
+SELECT * FROM hash_f8_heap
WHERE hash_f8_heap.random = '444705537'::float8;
--
-- hash index
-- grep 88888888 hash.data
--
-SELECT hash_f8_heap.*
+SELECT * FROM hash_f8_heap
WHERE hash_f8_heap.random = '88888888'::float8;
--