Clarification of Logical Operators in a PostGIS Database

Question

The following query returns this result:

select count(*) from a , b where a.geom && b.geom;

     count 
    -------
     66514

On a postgis 2 database.

What does the logical operator AND (&&) between two geometry columns return?

What about the other operators?

Edit: After a quick test it seems it returns all the rows where the bounding boxes of both the geometries overlap with each other

nickves · Accepted Answer · 2012-10-22 17:08:23Z

8

Array Functions and Operators (Postgres vs PostGIS)

edit: Returns TRUE if A's 2D bounding box intersects B's 2D bounding box.

enter image description here

Postgres Operator http://www.postgresql.org/docs/8.2/static/functions-array.html

Postgis Operators http://www.postgis.org/documentation/manual-2.0/reference.html#Operators

nickves

10.4k3 gold badges33 silver badges68 bronze badges

answered Oct 4 '12 at 21:30

Mapperz♦

46.7k7 gold badges65 silver badges124 bronze badges

1

See postgis.org/documentation/manual-2.0/reference.html#Operators for a PostGIS specific operator explanation. – lynxlynxlynx Oct 5 '12 at 13:05

add a comment |

1 Answer 1