[postgis-users] Update geometry

[Michael Fuhr]

On Wed, May 10, 2006 at 03:03:19PM -0500, Fernando Luyo wrote:
> the following line :
> 
> UPDATE ag_planosbn_18 SET geo_poligono = GeometryFromText('MULTIPOLYGON((278575.4298 8668096.767,278596.3218 8668096.767,278596.3218 8668107.4804,278575.4298 8668107.4804,278575.4298 8668096.767))',24878) WHERE gid = '10'
> 
> it gives east message me of error : 
> 
> ERROR:  couldnt parse object in GEOMETRY

I get a different error, but in any case multipolygons need more
parentheses:

postgis=> SELECT AsText(GeometryFromText('MULTIPOLYGON((0 0,5 5,10 0,0 0))'));
ERROR:  parse error - invalid geometry

postgis=> SELECT AsText(GeometryFromText('MULTIPOLYGON(((0 0,5 5,10 0,0 0)))'));
               astext               
------------------------------------
 MULTIPOLYGON(((0 0,5 5,10 0,0 0)))
(1 row)

-- 
Michael Fuhr