Re: [postgis-users] MultiLineStringZM

2012-07-19 Thread 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--'

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] MultiLineStringZM

2012-07-19 Thread Pedro Costa 


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