EWKB_PARSE_ERROR error condition

SQLSTATE: 22023

Error parsing EWKB: <parseError> at position <pos>

Parameters

• parseError: Description of the kind of parse error encountered.
• pos: The 1-based position in the EWKB binary string where the parse error occurred.

Explanation

Some geospatial functions can return this error when parsing the input that must be in Extended Well-Known Binary (EWKB) format.

Examples

SQL

-- Feeding a BINARY string with invalid endianness value into the st_geomfromewkb expression.
> SELECT st_geomfromewkb(X'120200000000000000')
  [EWKB_PARSE_ERROR] Error parsing EWKB: Invalid byte order 18 at position 1

Functions emitting the error class

• st_geomfromewkb function
• to_geometry function

Related

• GEOJSON_PARSE_ERROR error class
• WKB_PARSE_ERROR error condition
• WKT_PARSE_ERROR error condition