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

[strk at refractions.net]

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