[postgis-users] How to edit one point in multipolygon given dump path

[Paul moen]

Is there an easy quick way to edit a single point in a multipolygon  
given the path from a st_dump using sql?

It seem fast to parse the text string into arrays, splice the new  
point in deleting the old point and rebuilding the text for the  
multipolygon.

There has to be a better way using PostGIS and SQL, right?


Thanks,

Paul