range test for hash index?
От | Paul A Jungwirth |
---|---|
Тема | range test for hash index? |
Дата | |
Msg-id | CA+renyV=Us-5XfMC25bNp-uWSj39XgHHmGE9Rh2cQKMegSj52g@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: range test for hash index?
|
Список | pgsql-hackers |
Hello, I noticed the tests for range types do this: create table numrange_test2(nr numrange); create index numrange_test2_hash_idx on numrange_test2 (nr); Does that need a `using hash`? It seems like that's the intention. We only use that table for equality comparisions. The script already creates a table with a btree index further up. If I don't drop the table I can see it's not a hash index: regression=# \d numrange_test2 Table "public.numrange_test2" Column | Type | Collation | Nullable | Default --------+----------+-----------+----------+--------- nr | numrange | | | Indexes: "numrange_test2_hash_idx" btree (nr) Everything else passes if I change just that one line in the {sql,expected} files. Regards, Paul
В списке pgsql-hackers по дате отправления: