[postgis] Problem with query.

[Petri J. Riipinen]

Hi again,

By changing the query a bit it works.

SELECT GID, AsText(the_geom) AS geom, cityname
FROM cities
WHERE the_geom && GeometryFromText('BOX3D(3330000 6826000, 3331000 
6827000)'::BOX3D,-1);

I found this from internet, but that isn't shown on the doc example...:(

- Petriu

At 19:16 26.10.2001 , you wrote:
>Hi folks,
>
>I'm trying to execute this kind of query:
>--------------------
>SELECT GID, AsText(the_geom) AS geom, cityname
>FROM cities
>WHERE the_geom && GeometryFromText('BOX3D(3330000 6826000, 3331000
>6827000)',-1);
>--------------------
>
>And this is what I get in response:
>-------------------------------------
>ERROR: couldnt parse objects in GEOMETRY
>-------------------------------------
>
>Otherwise I can do queries into that table just fine.
>
>What could be wrong? I can't see any significant difference with the
>example query shown in PostGIS docs.
>
>- Petri
>
>PS. The 'cities'-table was originally imported to PostgreSQL with the
>shp2pgsql-program from PostGIS.
><><><><><><><><>
>    Petri J. Riipinen
>petri.riipinen at nic.fi
><><><><><><><><>
>
>
>To unsubscribe from this group, send an email to:
>postgis-unsubscribe at yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

<><><><><><><><>
   Petri J. Riipinen
petri.riipinen at nic.fi
<><><><><><><><>

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Pinpoint the right security solution for your company- Learn how to add 128- bit encryption and to authenticate your web site with VeriSign's FREE guide!
http://us.click.yahoo.com/yQix2C/33_CAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/