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

[Tom Lane]

Andrew Gierth  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

[HACKERS] 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)


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers