ST_CoordDim() method

Syntax

geometry-expression.ST_CoordDim()

Returns

SMALLINT Returns a value between 2 and 4 indicating the number of coordinate dimensions stored with each point of the ST_Geometry value.

Examples

• Example 1 – The following example returns the result 2.

  SELECT NEW ST_Point(1.0, 1.0).ST_CoordDim()

  The following example returns the result 3.

  SELECT NEW ST_Point(1.0, 1.0, 1.0, 0).ST_CoordDim()

  The following example returns the result 3.

  SELECT NEW ST_Point('Point M (1 1 1)' ).ST_CoordDim()

  The following example returns the result 4.

  SELECT NEW ST_Point('Point ZM (1 1 1 1)' ).ST_CoordDim()

Standards

SQL/MM (ISO/IEC 13249-3: 2006) 5.1.3