ERROR: GEOSIntersects: IllegalArgumentException: RobustDeterminant encountered non-finite numbers

[Gluchich]

ST_Intersects fails with error: ERROR: GEOSIntersects: IllegalArgumentException: RobustDeterminant encountered non-finite numbers

When one of the geometry like: POLYGON((-8482230.61661271 10018609.1889568,-8482230.61661272 10018609.1889568,-8482230.61661275 10018609.1889568,inf inf,inf inf,inf inf,inf inf …

Example in attached file.

Is it possible to RETURN NULL, for example, and continue to run query?

[dbaston]

You can write your own wrapper function to catch the exception and return NULL:

CREATE OR REPLACE FUNCTION ST_Intersection_NullOnError(geometry, geometry)
RETURNS geometry AS
$$
BEGIN
RETURN ST_Intersection($1, $2);
EXCEPTION
WHEN OTHERS THEN
RETURN NULL;
END
$$ LANGUAGE plpgsql;

[pramsey]

Returning NULL on an exception is out of scope. As noted, you can check invalidity yourself and strip those inputs from the query, or make an exception catching wrapper.