Re: Why is box <-> point missing, and box <-> box not indexable? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Why is box <-> point missing, and box <-> box not indexable?
Date
Msg-id 29207.1471015658@sss.pgh.pa.us
Whole thread Raw
In response to Why is box <-> point missing, and box <-> box not indexable?  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> point <-> point, circle <-> point and polygon <-> point all exist as
> orderable-by-operator operators (in fact they are the only ones by
> default). But there's no box <-> point operator at all, and no index
> support for box <-> box.

> Was this intentional, or just a strange oversight?

Seems like an oversight.  None of these operators have commutators,
but it seems like they all should:
<->(point,line)<->(point,lseg)<->(point,box)<->(lseg,line)<->(lseg,box)<->(point,path)<->(circle,polygon)<->(line,box)

Dunno about the index-support angle.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Why is box <-> point missing, and box <-> box not indexable?
Next
From: Tom Lane
Date:
Subject: Re: Fwd: [BUG] Print timing statistics of trigger execution under turned off timing option of EXPLAIN ANALYZE