Andrew Gierth <and...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers