[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis] Problem with query.
From: Paul Ramsey <pramsey () refractions ! net>
Date: 2001-10-26 16:33:56
Message-ID: 3BD99074.7C20828E () refractions ! net
[Download RAW message or body]
Color me embarrased. :) I have fixed the online docs appropriately.
"Petri J. Riipinen" wrote:
>
> 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@nic.fi
> > <><><><><><><><>
> >
> >
> > To unsubscribe from this group, send an email to:
> > postgis-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
> <><><><><><><><>
> Petri J. Riipinen
> petri.riipinen@nic.fi
> <><><><><><><><>
>
>
> To unsubscribe from this group, send an email to:
> postgis-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
------------------------ 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@yahoogroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic