12345678910111213 |
- -- The multipoint_test table is created with the gid smallint column
- -- that uniquely identifies the row and the mpt1 ST_MultiPoint column.
- CREATE TABLE multipoint_test (gid smallint,
- mpt1 ST_MultiPoint);
- -- The INSERT statement inserts a multipoint into
- -- the mpt1 column using the ST_MPointFromText function.
- INSERT INTO multipoint_test VALUES(
- 1,
- ST_MPointFromText('multipoint(10.01 20.03,10.52 40.11,30.29 41.56,31.78 10.74)',1000)
- );
|