\pset tuples_only on \set string '\'801dfffffffffff\'' \set asbigint 576988517884755967 \set hexagon ':string::h3index' \set pentagon '\'844c001ffffffff\'::h3index' -- -- TEST operators -- SELECT :hexagon = :hexagon; SELECT NOT :hexagon = :pentagon; SELECT NOT :hexagon <> :hexagon; SELECT :hexagon <> :pentagon; SELECT :pentagon <@ h3_cell_to_parent(:pentagon); SELECT bool_and(:pentagon @> c) FROM ( SELECT h3_cell_to_children(:pentagon) c ) q; -- -- TEST bigint casting -- SELECT :asbigint = :hexagon::bigint; SELECT :hexagon = :asbigint::h3index;