Hi there Paul, thanks for looking at this. I'm going to try pg's regexp,replace() and see if i can come up with an expression that will take out " Z", " M", and " ZM" in one pass. Today I'm out of the office, but will try tomorrow and report back.
Maybe regexp.replace(st_astext(geom), '.*Z|.*M|.*ZM' , '') ) will do it. best, Duarte -- View this message in context: http://postgis.17.n6.nabble.com/z-m-zm-geometries-tp4981255p4991926.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
