Обсуждение: Why is box <-> point missing, and box <-> box not indexable?

Поиск
Список
Период
Сортировка

Why is box <-> point missing, and box <-> box not indexable?

От
Andrew Gierth
Дата:
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?

-- 
Andrew (irc:RhodiumToad)



Re: Why is box <-> point missing, and box <-> box not indexable?

От
Tom Lane
Дата:
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