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
