[postgis-users] function geomfromtext(box3d, integer) does not exist

strk at refractions.net strk at refractions.net
Wed Apr 20 08:18:42 PDT 2005


Fixed. Thanks!
--strk;

On Wed, Apr 20, 2005 at 03:09:58PM +0200, Achim Weßling wrote:
> Sorry for my late breaking understanding!!!
> 
> Now it works fine!
> 
> So I give you another hint for the docu ;-). You reference to the
> SimpleFeature Specification for SQL with the following URL which does
> not work:
> 
> http://www.opengis.org/techno/specs/99-049.pdf
> 
> The right URL is: http://www.opengis.org/docs/99-049.pdf. But I think
> you better say that the specification can be found at
> http://www.opengis.org.
> 
> Thanks
> 
> Achim
> 
> Am Mi, den 20.04.2005 schrieb strk at refractions.net um 13:53:
> > SetSRID replaces GeomFromText.
> > GeomFromText, as name suggests accepts TEXT, not BOX3D, not GEOMETRY.
> > SetSRID accepts GEOMETRY, and feeding it a BOX3D works relying on
> > BOX3D::GEOMETRY cast.
> > --strk;
> > 
> > On Wed, Apr 20, 2005 at 02:36:52PM +0200, Achim Weßling wrote:
> > > Sorry ;-)
> > > 
> > > but after changing my SELECT as follows:
> > > 
> > > SELECT objnr, objart, bemerkung, asText(the_geom) AS the_geom 
> > >     FROM f001_e_fla 
> > >     WHERE the_geom && GeomFromText(setsrid('BOX3D(3446100 5773647,
> > > 3446321 5773823)'::box3d, 31467));
> > > 
> > > I get:  Error: ERROR: Invalid OGC WKT (does not start with P,L,M or G)
> > > 
> > > Again this works on 0.8.1, but doesn't on 1.0.0RC6!
> > > 
> > > Achim
> > > 
> > > Am Mi, den 20.04.2005 schrieb strk at refractions.net um 13:19:
> > > > On Wed, Apr 20, 2005 at 02:09:46PM +0200, Achim Weßling wrote:
> > > > > So,
> > > > > 
> > > > > can someone tell me how the right syntax looks like?
> > > > 
> > > > SetSRID('BOX3D(...)'::box3d, SRID)
> > > > --strk;
> > > > 
> > > > > 
> > > > > Achim
> > > > > 
> > > > > Am Mi, den 20.04.2005 schrieb strk at refractions.net um 12:23:
> > > > > > On Wed, Apr 20, 2005 at 12:20:09PM +0200, Markus Schaber wrote:
> > > > > > > Hi, Strk,
> > > > > > > 
> > > > > > > strk at refractions.net schrieb:
> > > > > > > 
> > > > > > > > I've fixed this in current CVS.
> > > > > > > > Unfortunately it didn't get into 1.0.0.
> > > > > > > 
> > > > > > > That was fast. Did you "backport" it into the 1.0.0 branch so it gets
> > > > > > > into 1.0.1 should that get necessary for other reasons?
> > > > > > 
> > > > > > Forgot it. Now done.
> > > > > > --strk;
> > > > > > 
> > > > > > > 
> > > > > > > Markus
> > > > > > > _______________________________________________
> > > > > > > postgis-users mailing list
> > > > > > > postgis-users at postgis.refractions.net
> > > > > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > > > > _______________________________________________
> > > > > > postgis-users mailing list
> > > > > > postgis-users at postgis.refractions.net
> > > > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > > > 
> > > > > _______________________________________________
> > > > > postgis-users mailing list
> > > > > postgis-users at postgis.refractions.net
> > > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > > _______________________________________________
> > > > postgis-users mailing list
> > > > postgis-users at postgis.refractions.net
> > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > 
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list