[postgis-devel] Btree operators

[Sandro Santilli]

On Thu, Apr 07, 2016 at 03:06:56PM +0000, Komяpa wrote:
> чт, 7 апр. 2016 г. в 17:39, Paul Ramsey <pramsey at cleverelephant.ca>:
> 
> > Speed is a benefit. Once you start down the road of = semantics, the
> > question of "which equals" looms large. Spatial equality?
> > Representational equality? Equality within a tolerance? Doing a string
> > compare is basically the only one that doesn't impose a surprising
> > cost, and it is, as you say, noisy.
> 
> The equality that is the same as string compare would be a lot less
> surprising.
> It shouldn't be slower than bbox equality with recheck for the case when
> they're equal.

We don't even need to convert to string, actually.
A memcmp call would be pretty fast.

--strk;