ST_Validate()¶

Passes through a structurally valid geometry and returns NULL for an invalid one.

Syntax¶

ST_Validate(geom)

Aliases: none.

Arguments¶

geom is a GEOMETRY or GEOMETRY32 value.

Return Value¶

Returns the same geometry type as geom; invalid or NULL input produces NULL.

Usage Notes¶

Use this function when a query should discard invalid geometries without raising a validity result separately.

Examples¶

DROP DATABASE IF EXISTS geo_validate_demo;
CREATE DATABASE geo_validate_demo;
USE geo_validate_demo;

SELECT ST_AsText(ST_Validate(ST_GeomFromText('POLYGON((0 0, 4 0, 4 4, 0 4, 0 0))'))) AS valid_geometry,
       ST_Validate(ST_GeomFromText('POLYGON((0 0, 4 4, 4 0, 0 4, 0 0)')) IS NULL AS invalid_is_null;

DROP DATABASE geo_validate_demo;

See Also¶

ST_IsValid(), ST_IsSimple().