H3_INVALID_RESOLUTION_VALUE error class

  • Article

SQLSTATE: 22023

H3 resolution <r> must be between <minR> and <maxR>, inclusive

Parameters

  • h3Cell: An input value that was expected to correspond to a valid H3 cell ID.
  • r: The actual resolution value (an INTEGER), passed to the SQL function.
  • minR: The minimum acceptable resolution (an INTEGER) in the context of the SQL function (usually 0).
  • maxR: The maximum acceptable resolution (an INTEGER) in the context of the SQL function (usually 15).

Explanation

Functions that emit this error expect a valid H3 resolution value. Valid H3 resolution values are between 0 and 15. Some SQL functions may restrict the range even further based on the function's context.

Examples

-- Invoking h3_longlatash3 with a resolution that is out of the valid range.
> SELECT h3_longlatash3(40, -120, 16);
  [H3_INVALID_RESOLUTION_VALUE] H3 resolution 16 must be between 0 and 15, inclusive

-- Invoking h3_toparent with a resolution that is larger than the input cell's resolution.
> SELECT h3_toparent(599686042433355775, h3_resolution(599686042433355775) + 1);
  [H3_INVALID_RESOLUTION_VALUE] H3 resolution 6 must be between 0 and 5, inclusive

Functions emitting this error class