[postgis-users] MultiLineStringZM

Pedro Costa pedrocostaarma at sapo.pt
Thu Jul 19 04:37:11 PDT 2012


Thank you Sandro Santilli

I resolved with force2d





Em 19-07-2012 12:18, Sandro Santilli escreveu:
> 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------'
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list