ST_Point returns an ST_Point, given an x-coordinate, y-coordinate, and spatial reference ID.
Oracle
sde.st_point (wkt clob, srid integer)
sde.st_point (x number, y number, srid integer)
sde.st_point (x number, y number, m number, srid integer)
sde.st_point (x number, y number, z number, srid integer)
sde.st_point (x number, y number, z number, m number, srid integer)
PostgreSQL
st_point (wkt, srid integer)
st_point (esri_shape bytea, srid integer)
st_point (x double precision, y double precision, srid integer)
st_point (x double precision, y double precision, m double precision, srid integer)
st_point (x double precision, y double precision, z double precision, srid integer)
st_point (x double precision, y double precision, z double precision, m double precision, srid integer)
The following CREATE TABLE statement creates the POINT_TEST table, which has a single point column, pt1.
Oracle
CREATE TABLE POINT_TEST (pt1 sde.st_geometry);
PostgreSQL
CREATE TABLE POINT_TEST (pt1 st_geometry);
The ST_Point function converts the point coordinates into an ST_Point geometry before the INSERT statement inserts it into the pt1 column.
Oracle
INSERT INTO point_test VALUES (
sde.st_point (10.01, 20.03, 0)
);
PostgreSQL
INSERT INTO point_test VALUES (
st_point (10.01, 20.03, 0)
);