st_x function

Applies to: Databricks SQL Databricks Runtime 17.1 and above

Preview

This feature is in Public Preview.

注記

This feature is not available on Databricks SQL Classic warehouses. To learn more about Databricks SQL warehouses, see SQL warehouse types

Returns the X coordinate of the input point GEOMETRY, or NULL if the point is empty.

Syntax

st_x ( geoExpr )

Arguments

• geoExpr: A GEOMETRY value.

Returns

A value of type DOUBLE, X coordinate of the input point GEOMETRY.

The function returns NULL if the input is NULL or if the point is empty.

Error conditions

• If the value of geoExpr is not a point, the function returns ST_INVALID_ARGUMENT.INVALID_TYPE.

Examples

SQL

-- Returns the X coordinate of a non-empty point geometry.
> SELECT st_x(st_geomfromtext('POINT Z (2 3 4)'));
  2.0
-- Returns `NULL` for an empty point geometry.
> SELECT st_x(st_geomfromtext('POINT ZM EMPTY'));
  NULL

Related functions

• st_m function
• st_xmax function
• st_xmin function
• st_y function
• st_z function