ST_AsInt converts an H3 geographic grid object (h3grid) to its bigint representation.
Syntax
bigint ST_AsInt(h3grid grid);Parameters
| Parameter | Type | Description |
|---|---|---|
grid | h3grid | The H3 geographic grid object to convert. |
Return value: A bigint representing the H3 cell index.
Example
SELECT ST_AsInt(ST_H3FromBinary('\x010100ffff9f6826a18408'));Output:
st_asint
--------------------
613792635565375487