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.8k3 gold badges36 silver badges71 bronze badges

answered Oct 4 '12 at 21:30

Mapperz♦

47.7k9 gold badges67 silver badges129 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