\pset tuples_only on
\set string '\'801dfffffffffff\''
\set hexagon ':string::h3index'
\set pentagon '\'844c001ffffffff\'::h3index'
-- Type conversions
SELECT h3_string_to_h3(h3_h3_to_string(:hexagon)) = :hexagon;
 t

SELECT h3_h3_to_string(h3_string_to_h3(:string))::text = :string::text;
 t

--
-- TEST operators
--
SELECT :hexagon = :hexagon;
 t

SELECT NOT :hexagon = :pentagon;
 t

SELECT NOT :hexagon <> :hexagon;
 t

SELECT :hexagon <> :pentagon;
 t

--
-- TEST b-tree index
--
CREATE TABLE h3_test_type (hex h3index PRIMARY KEY);
INSERT INTO h3_test_type (hex) SELECT * from h3_basecells();
SELECT hex = :hexagon FROM (
    SELECT hex FROM h3_test_type WHERE hex = :hexagon
) q;
 t