[postgis-users] Get more polygon's exterior boundary

[Kis János Tamás]

Hi,

If I have some POLYGON in the subjunctive table:

DROP TABLE IF EXISTS try;
CREATE TABLE try
( id serial NOT NULL,
  the_name character varying(10),
  the_geom geometry,
  CONSTRAINT pk_try PRIMARY KEY (id));

INSERT INTO try (the_name, the_geom) VALUES ('1A',
GeomFromText('POLYGON((10 10,10 20,20 20,20 10,10 10),(13 18,18 18,18
13,13 13,13 18))',-1));
INSERT INTO try (the_name, the_geom) VALUES ('1B',
GeomFromText('POLYGON((13 18,18 18,18 13,13 13,13 18))',-1));
INSERT INTO try (the_name, the_geom) VALUES ('2',
GeomFromText('POLYGON((20 10,20 20,30 20,30 10,20 10))',-1));
INSERT INTO try (the_name, the_geom) VALUES ('3',
GeomFromText('POLYGON((10 20,10 30,30 30,30 20,20 20,10 20),(13 23,23
23,23 28,13 28,13 23))',-1));

How can I get the next polygon?
POLYGON((10 10, 10 20,10 30,30 30,30 20,30 10,10 20,10 10),(13 23,23
23,23 28,13 28,13 23))

Thx,
kjt




McAfee SCM 4.1 által ellenőrizve!