[postgis-users] box3d

Jürgen Mischker juergen.mischker at boku.ac.at
Mon Mar 13 00:51:21 PST 2006

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

... 'BOX3D(90900 190900, 100100 200100)'::box3d...
doesn`t work:
ERROR: BOX3D parser - doesnt start with BOX3d(

CHeers for all your help

DDI Jürgen Mischker
Insitut f. Vermessung, Fernerkundung und Landinformation,
Universität für Bodenkultur, BOKU, Wien
Institute of Surveying, Remote Sensing and Land Information.
University of Natural Resources and Applied Life Science, Vienna.
Tel.: +43 1 47654-5132
Fax.: +43 1 47654-5142
email: jmischker at boku.ac.at

More information about the postgis-users mailing list