ST_IsValidReason

Returns a text explanation describing why a geometry is invalid.

Usage

string ST_IsValidReason(geom: geometry)

Arguments

• geom (geometry): Input geometry

Description

Returns a text string explaining why a geometry is invalid, or "Valid Geometry" if the geometry is valid. Useful for debugging geometry construction.

Examples

SELECT ST_IsValidReason(
    ST_GeomFromText('POLYGON((0 0, 2 0, 2 2, 1 1, 0 2, 0 0))')
) AS reason;

┌────────────────┐
│     reason     │
│      utf8      │
╞════════════════╡
│ Valid Geometry │
└────────────────┘