[postgis-users] Equality operator for type box2d

Nick Ves vesnikos at gmail.com
Tue Apr 21 01:58:21 PDT 2015


I was playing with the ST_Extent today and I wanted to try a query like this:

select distinct ST_Extent(geom)  over () box from parcels_test

where the geom is Type ST_Polygon but I got this error instead:

  ERROR:  could not identify an equality operator for type box2d

The aim was to get the BBox from a set of polygons that might or might
not be adjutant. Ofc you can get the same results by limit the result
to 1 but, it hitted me strange box2d type not having an equal operator

using "POSTGIS="2.1.4 r12966" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel.
4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24"
LIBXML="2.9.1" LIBJSON="UNKNOWN" RASTER"


More information about the postgis-users mailing list