[postgis-users] Operator does not exist: <<#>>

Regina Obe lr at pcorp.us
Tue Dec 26 11:46:00 PST 2023


I concur doesn’t seem to exist.  I’m trying to think how that would ever have been different from <#>.

 

I recall there was a time before we had true KNN for geometry that one was for bounding box distance and one was for the centroid bounding box distance.

 

Anyway I’ll remove from the docs.  Thanks for catching.

 

Regina

 

From: postgis-users <postgis-users-bounces at lists.osgeo.org> On Behalf Of Dapeng Wang via postgis-users
Sent: Monday, December 25, 2023 10:31 PM
To: postgis-users at lists.osgeo.org
Cc: Dapeng Wang <wangdapeng20191008 at gmail.com>
Subject: [postgis-users] Operator does not exist: <<#>>

 

Hello everyone,

SELECT st_distance(geom, 'SRID=4326;POINT(1 2)'::geometry)
FROM ne_110m_admin_0_countries
ORDER BY (ST_GeomFromText('POINT(1 2)') <<#>> geom)
operator does not exist: geometry <<#>> geometry
Reference https://postgis.net/docs/manual-dev/en/geometry_distance_box_nd.html


Checked the postgis.sql.in <http://postgis.sql.in>  source code definition and did not find this operator. Has it been abandoned?

Thanks,
Dapeng

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20231226/e0d87946/attachment.htm>


More information about the postgis-users mailing list