[postgis-users] box3d

[Jürgen Mischker]

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(


CHeers for all your help
juergen


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