I added a new column. alter table a_table add column geom geometry(Polygon, 27700);
Then, update a_table set geom = (select ST_ConcaveHull(ST_Collect(geom), 0.99) from b_table where name = _name) where name = _name; It kept throwing up an error message saying: "geometry type point does not match polygon". I thought that a concavehyll is a polygon. That is why I created a polygon column for it. Can anyone help? Regards, Shao
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users