\pset tuples_only on
\set string '\'801dfffffffffff\''
\set hexagon ':string::h3index'
CREATE TABLE h3_test_brin (hex h3index PRIMARY KEY);
INSERT INTO h3_test_brin (hex) SELECT * FROM h3_get_res_0_cells();
CREATE INDEX h3_brin ON h3_test_brin USING brin (hex);
--
-- Test BRIN operator class
--
SELECT hex = :hexagon FROM (
  SELECT hex FROM h3_test_brin WHERE hex = :hexagon
) q;
 t