Hi
you have to input a string to geomtfromtext
like this:
GeomFromText('MULTIPOLYGON(((-119.2 33.46, -118.7 333.46, -118.7 32.66, -119.2
33.66, -119.2 33.46))) ')
/Nicklas Avén
2009-04-24 Malm Paul wrote:
>Hi,>I´m trying this:>SELECT submapid, mapid, blob, AsText(the_geom) as
>the_geom >FROM submap WHERE
>the_geom && GeomFromText(MULTIPOLYGON(((-119.2 33.46, -118.7 333.46,
>-118.7 32.66, -119.2 33.66, -119.2 33.46))) )
>>I´ve also tried this:>>SELECT submapid, mapid, blob, AsText(the_geom) as
>>the_geom >FROM submap WHERE
>the_geom && GeomFromText(MULTIPOLYGON(((-119.2 33.46, -118.7 333.46,
>-118.7 32.66, -119.2 33.66))) ) > >>
But all I'm getting is this:>
>ERROR: syntax error at or near "33.46"
>RAD 2: the_geom && GeomFromText(MULTIPOLYGON(((-119.2 33.46, -118....
> ^>
********** Error **********>
ERROR: syntax error at or near "33.46"
>SQL state: 42601
>Character: 127>
>
>
I would be happy if someone could tell me what I´m doing wrong?>
>
Kind regards,>
Paul
>>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
