[postgis-users] GIST index

David Bitner osgis.lists at gmail.com
Fri Feb 17 12:51:22 PST 2006


Does the GIST index work for all of the operators, or just &&?

If I was trying to determine quickly if line crossed a perfectly
rectangular (in the projection that I was working in) box, could I do
this fully using index scans by using something like:
where line_geom && box_geom and !(line_geom @ box_geom)

Thanks,
David



More information about the postgis-users mailing list