ST_M

Definición

ST_M toma un ST_Point como un parámetro de entrada y devuelve las coordenadas de medida (m).

Sintaxis

sde.st_m (g1 sde.st_point)

Tipo de devolución

Número

Ejemplo

Oracle

CREATE TABLE m_test (id integer, geometry sde.st_point);  INSERT INTO M_TEST VALUES ( 1, sde.st_point (2, 3, 32, 5, 0) );  INSERT INTO M_TEST VALUES ( 2, sde.st_point (4, 5, 20, 4, 0) );  INSERT INTO M_TEST VALUES ( 3, sde.st_point (3, 8, 23, 7, 0) );  SELECT id, sde.st_m (geometry) M_COORD FROM M_TEST;           ID    M_COORD           1          5          2          4          3          7

PostgreSQL

CREATE TABLE m_test (id integer, geometry sde.st_point);  INSERT INTO m_test VALUES ( 1, sde.st_point (2, 3, 32, 5, 0) );  INSERT INTO m_test VALUES ( 2, sde.st_point (4, 5, 20, 4, 0) );  INSERT INTO m_test VALUES ( 3, sde.st_point (3, 8, 23, 7, 0) );  SELECT id, sde.st_m (geometry)  AS M_COORD FROM m_test;           id    m_coord           1          5          2          4          3          7