st_point.sql 362 B

1234567891011
  1. -- The following CREATE TABLE statement creates the point_test table,
  2. -- which has a single point column, pt1.
  3. CREATE TABLE point_test (pt1 ST_Point);
  4. -- The ST_Point function converts the point coordinates into a ST_Point
  5. -- geometry before the INSERT statement inserts it into the pt1 column.
  6. INSERT INTO point_test VALUES(
  7. ST_Point(10.01,20.03,1000)
  8. );