File: opclass_hash.sql

package info (click to toggle)
h3-pg 4.2.3-3
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 1,196 kB
  • sloc: sql: 4,469; ansic: 3,497; python: 322; sh: 56; makefile: 18
file content (14 lines) | stat: -rw-r--r-- 427 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
\pset tuples_only on

CREATE TABLE h3_test_hash (hex h3index PRIMARY KEY);
INSERT INTO h3_test_hash (hex) SELECT * from h3_get_res_0_cells();
CREATE INDEX h3_btree ON h3_test_hash USING hash (hex);

--
-- TEST hash operator class
--
SELECT COUNT(hex) = 122 FROM (
    SELECT hex FROM h3_test_hash WHERE hex IN (SELECT h3_get_res_0_cells())
) q;

CREATE TABLE h3_test_hash_part (hex h3index PRIMARY KEY) PARTITION BY HASH (hex);