Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Spatial Data User's GuideThe HCL OneDB™ Spatial Data User's Guide contains information to assist you in using the HCL® OneDB® spatial extension. The HCL® OneDB® spatial extension adds custom data types and supporting routines to the server.
Spatial functionsUse specific spatial data type functions to perform operations on spatial data.
The SE_Midpoint() function

The SE_Midpoint() function

The SE_Midpoint() function determines the midpoint of a linestring. The midpoint is defined as that point which is equidistant from both endpoints of a linestring, measuring distance along the linestring.

If the input linestring has Z values or measures, the Z value or measure of the midpoint are computed by linear interpolation between the adjacent vertices.

Syntax

SE_Midpoint (ln1 ST_LineString)

Return type

ST_Point