hi arnaud thanks for your reply. i think using addpoint will be a good way. but i don't how to apply that on a multipolygon where i have maybe some polygons (which are not closed) in one multipolygon. appending one point to such multipolygon would only close one polygon of the multipolygon, wouldn't it? so, is there maybe a good solution for a multipolygon?
regards, stefan > > I don't know about the polygonize stuff, but > > Stefan Zweig a écrit : > > is there maybe another way to insert the first point again after the last > > point? > > Here you can use ST_AddPoint : > > ST_AddPoint(linestring, point, [<position>]) > Adds a point to a LineString before point <pos> (0-based index). Third > parameter can be omitted or set to -1 for appending. > > So "ST_AddPoint(the_geom, ST_PointN(the_geom, 1))" would return the_geom with > its first point appended at the end. > > > Regards, > -- > Arnaud > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _____________________________________________________________________ Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! http://smartsurfer.web.de/?mc=100071&distributionid=000000000066 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
