[postgis-users] Adding new points to multipoints and new polygons to multipolygons

[strk]

On Tue, May 25, 2010 at 09:29:05PM -0400, James Chamberlain wrote:
> Hello,
> 
> What is the best way to add a new point to a multipoint or a new polygon 
> to a multipolygon while maintaining order. I read about using union, but 
> it will not keep the order and therefore will not work for me. Speed and 
> efficiency are important as these updates will happen frequently.

See ST_AddPoint and ST_AddGeometry.
The latter should work in both cases.
If it doesn't, file a feature request as I think it should :D

--strk;


  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html