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

[Achim Weßling]

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