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