ST_X(DOUBLE) method for type ST_Point

Returns a copy of the point with the X coordinate set to the specified xcoord value.

Note

If the point-expression is an empty geometry (ST_IsEmpty()=1), then this method returns NULL.

Note

By default, ST_X uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

 Syntax
 Parameters
 Returns
 Standards and compatibility