[postgis-users] MultiLineStringZM

[Sandro Santilli]

On Thu, Jul 19, 2012 at 11:35:50AM +0100, Pedro Costa wrote:
> Hello people,
> 
> I have one column that is 'MultiLineStringZM'.
> How do i turn this geom in 2d?

ALTER TABLE mytable ALTER mycolumn
 TYPE geometry(MultiLineString) 
 WITH st_force2d(mycolumn);

The last one could be "USING" rather than "WITH", and there
could be some other SQL syntax error. Refer to PostgreSQL
manual abut "ALTER TABLE".

--strk; 

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.1
  |  / 2.1 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'