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 ST_IsValid() function

The ST_IsValid() function

The ST_IsValid() function takes an ST_Geometry and returns t (TRUE) if it is topologically correct; otherwise it returns f (FALSE). Properties of geometries are described in ids_spat_036.html.

The database server validates spatial data before accepting it, so ST_IsValid() always returns TRUE. This function may be used to validate spatial data supplied by other implementations of the OpenGIS spatial data specification.

Syntax

ST_IsValid(g ST_Geometry)

Return type

BOOLEAN