Name
ST_HasZ — Checks if a geometry has a Z dimension.
Synopsis
boolean ST_HasZ(geometry geom);
Description
Checks if the input geometry has a Z dimension and returns a boolean value. If the geometry has a Z dimension, it returns true; otherwise, it returns false.
Geometry objects with a Z dimension typically represent three-dimensional (3D) geometries, while those without it are two-dimensional (2D) geometries.
This function is useful for determining if a geometry has elevation or height information.
Availability: 3.5.0
This function supports 3d and will not drop the z-index.
This function supports M coordinates.
Examples
Code
SELECT ST_HasZ('POINT(1 2 3)');
Output
t
Code
SELECT ST_HasZ('LINESTRING(0 0,1 1)');
Output
f
Figure