File: opclass_btree.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 (13 lines) | stat: -rw-r--r-- 393 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
\pset tuples_only on
\set string '\'801dfffffffffff\''
\set hexagon ':string::h3index'

CREATE TABLE h3_test_btree (hex h3index PRIMARY KEY);
INSERT INTO h3_test_btree (hex) SELECT * from h3_get_res_0_cells();
CREATE INDEX h3_btree ON h3_test_btree USING btree (hex);
--
-- TEST b-tree operator class
--
SELECT hex = :hexagon FROM (
    SELECT hex FROM h3_test_btree WHERE hex = :hexagon
) q;