[postgis-users] MultiLineStringZM
Hello people, I have one column that is 'MultiLineStringZM'. How do i turn this geom in 2d? Thanks ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] MultiLineStringZM
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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] MultiLineStringZM
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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users