Using a postgis table with Two polygons, in which polygon 1 entirely
contained in polygon 2, I've create a new polygon with a hole using :
------
create table matable2 as
select r.gid, area(symdifference(r.the_geom,i.the_geom)) as area,
(symdifference(r.the_geom,i.the_geom)) as the_geom from matable as r,
matable as i where i.gid=2 and r.gid=1;
ALTER TABLE matable2 ADD PRIMARY KEY (GID);
\q
pgsql2shp -f ext.shp conversion 'select * from matable2'
-----
Area is correct, display of the polygon in QGIS is also correct, but
the export by pgsl2shp produce an empty shapefile.
How to deal with this problem?
------------------------------------------
Geniaux Ghislain
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
