[postgis-devel] Bug in default B-Tree operator class for geography

[Paul Ramsey]

You're cruel, cruel, cruel. (And you have a perverse mind to even
*conceive* of the sorting-different-kinds-of-empty problem)
Of course, yes, z-order is v. much something I want to do, but in this run,
trying to stay ahead of Regina's release-monster, just avoiding bad index
semantics for pgsql is the goal. The non-deterministic nature of different
kinds of empty is one I hadn't considered, but I think has to be handled,
yay! I'll do that now.
P

On Mon, Sep 11, 2017 at 7:37 AM, Darafei "Komяpa" Praliaskouski <
me at komzpa.net> wrote:

> What happens on LINESTRING EMPTY < POINT EMPTY?
>
> Also, ordering in geohash / z-curve would make many spots where it's used
> a lot more efficient :)
>
> пн, 11 сент. 2017 г. в 17:31, Paul Ramsey <pramsey at cleverelephant.ca>:
>
>> I took a stab at it in https://trac.osgeo.org/postgis/ticket/3841
>>
>> Any spelunk into the b-tree side re-raises questions about "what do we
>> mean by equal" and "how should we sort", making we want to tear off the
>> bandages and try again.
>>
>> On Sun, Sep 10, 2017 at 5:05 PM, Peter Geoghegan <pg at bowt.ie> wrote:
>>
>>> Hi Paul,
>>>
>>> On Wed, Aug 24, 2016 at 8:25 AM, Paul Ramsey <pramsey at cleverelephant.ca>
>>> wrote:
>>> > Thanks for this Peter.
>>> > Fortunately b-tree opclasses on geom/geog are but rarely used and even
>>> more
>>> > rarely build into actual indexes, since they don't provide any useful
>>> > spatial searching capability.
>>>
>>> When do you expect to get around to fixing this? With amcheck in
>>> Postgres 10, I would expect more people to notice this.
>>>
>>> Thanks
>>> --
>>> Peter Geoghegan
>>>
>>
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20170911/10aaac2b/attachment.html>