EWKT_PARSE_ERROR error condition

SQLSTATE: 22023

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

Parameters

• parseError: Description of the kind of parse error encountered.
• pos: The 1-based position in the EWKT 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 Text (EWKT) format.

Examples

SQL

-- Feeding a string with invalid SRID value into the `to_geometry` expression.
> SELECT to_geometry('SRID=-1;POINT(1 2)');
  [EWKT_PARSE_ERROR] Error parsing EWKT: Invalid or unsupported SRID value '-1' at position 6 SQLSTATE: 22023

Functions emitting the error class

• st_geogfromewkt function
• st_geomfromewkt function
• to_geography function
• to_geometry function

Related

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