[postgis-users] box3d

Michael Fuhr mike at fuhr.org
Mon Mar 13 07:44:50 PST 2006


On Mon, Mar 13, 2006 at 09:51:21AM +0100, Jürgen Mischker wrote:
> I try to get a box to test performance of my index. i copied the part from the doku:
> 
> SELECT the_geom FROM geom_table
> WHERE the_geom && 'BOX3D(90900 190900, 100100 200100)'::box3d
>   AND distance( the_geom, GeomFromText( 'POINT(100000 200000)', -1 ) ) < 100
> 
> BUT: 
> ... 'BOX3D(90900 190900, 100100 200100)'::box3d...
> doesn`t work:
> ERROR: BOX3D parser - doesnt start with BOX3d(

Are those the exact query and error message, pasted into the message
rather than typed?  If so then it seems odd that the BOX3D parser is
complaining that the geometry doesn't start with 'BOX3d' (lowercase
'd') when it should be 'BOX3D' (uppercase 'D').

-- 
Michael Fuhr



More information about the postgis-users mailing list