A th3index value shares the same on-disk representation as tbigint. The binary-coercion cast between them is explicit — requiring :: — so h3index-specific functions cannot be silently called on arbitrary bigint trajectories.
Convert between a th3index and a tbigint (explicit, zero-cost)
tbigint::th3index
th3index::tbigint
SELECT (tbigint '590464338553208831@2001-01-01')::th3index; -- 831c02fffffffff@2001-01-01 SELECT ((th3index '831c02fffffffff@2001-01-01')::tbigint)::th3index = th3index '831c02fffffffff@2001-01-01'; -- true
Cast a temporal H3 cell to a temporal geodetic / planar point of cell centroids. The two overloads give the caller a choice between the geodetic (tgeogpoint) and SRID-4326 planar (tgeompoint) representations.
th3index::tgeogpoint
th3index::tgeompoint
SELECT (th3index '831c02fffffffff@2001-01-01')::tgeogpoint; SELECT (th3index '831c02fffffffff@2001-01-01')::tgeompoint;