analytics/informix/extend/spatial.8.22.FC2/examples/sql/se_ismeasured.sql

-- The measure_test table is created with two columns:
-- a smallint column, gid, uniquely identifies the rows,
-- while g1, a ST_Geometry column, stores the ST_Point geometries.

CREATE TABLE measure_test (gid smallint,
                           g1  ST_Geometry);

-- The INSERT statements insert two records into the measure_test
-- table. The first record stores a point that doesn't have a measure,
-- while the second record does have a measure value.

INSERT INTO measure_test VALUES(
    1,
    ST_PointFromText('point (10 10)',1000)
);

INSERT INTO measure_test VALUES(
    2,
    ST_PointFromText('point m (10.92 10.12 5)',1000)
);

-- The query lists the gid column and the results of
-- the SE_IsMeasured function. The SE_IsMeasured function
-- returns f (FALSE) for the first row because the point does not
-- have a measure, and it returns t (TRUE) for the second row because
-- the point does have measures.

SELECT gid,SE_IsMeasured(g1) Has_measures 
   FROM measure_test;