[postgis-users] dropping bboxes doesn't work ?!

[strk at refractions.net]

On Mon, Oct 17, 2005 at 11:01:34AM +0200, "R. Müller" wrote:
> hallo,
> 
> strk at refractions.net wrote:
> > I get correct result with current CVS:
> >
> > 	SELECT hasbbox('LINESTRING(0 0, 1 1)');
> > 		t
> >
> > 	SELECT hasbbox(dropbbox('LINESTRING(0 0, 1 1)'));
> > 		f
> 
> 
> good news : this seems to be not the problem, it works as well for me.
> 
> but in my cases the following query reports :
> 
> 'select box2d(geom),hasbbox(geom),astext(geom) from geotable limit 1'
> 
> "BOX(97622 1047225,97825 1047410)";t;"LINESTRING(9.7825 52.36125,9.7804 
> 52.3615,9.7649 52.3677,9.7622 52.3705)"
> 
> 'select astext(dropbbox(geom)) from geotable'  returns in the first row
> 
> "LINESTRING(9.7825 52.36125,9.7804 52.3615,9.7649 52.3677,9.7622 52.3705)"
> 
> after that the first query returns the same result as above :-( !?

It is normal behaviour.
You never update the table, so the query returns the same result.
If you want to store the geometry in table w/out bounding box
(do you really want this?) you have to do something like:

	update MyTable set the_geom = dropbbox(the_geom);

--strk;


> 
> ronald
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users