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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why is box <-> point missing, and box <-> box not indexable?
Дата
Msg-id 29207.1471015658@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Why is box <-> point missing, and box <-> box not indexable?  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Why is box <-> point missing, and box <-> box not indexable?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Fwd: [BUG] Print timing statistics of trigger execution under turned off timing option of EXPLAIN ANALYZE