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

-- This example demonstrates how to use the SE_Is3D function to determine
-- if a geometry has three dimensional coordinates

CREATE TABLE threed_test (gid   smallint,
                          g1    ST_Geometry);

-- Insert a three dim and a two dim coordinates
INSERT INTO threed_test VALUES(
   1, ST_PointFromText('point (10 10)',1000)
);

INSERT INTO threed_test VALUES(
   1, ST_PointFromText('point z(10.92 10.12 5)',1000)
);


-- The query lists all the columns being 3d or not

SELECT gid, SE_Is3D (g1) is_it_3d from threed_test;