Re: point <-> polygon not supported?

Scott Ding wrote:
> I’m using version 7.3.2. I got the following error when I executed the
> sql statement in psql:
<cut>
> Does this mean that the <-> operator does not support distance between a
> point and a simple polygon?
No.

Try this query:
select o.oprname,t1.typname as left, t2.typname as right
from pg_operator o join pg_type t1 on (o.oprleft=t1.oid) join pg_type t2 on (o.oprright=t2.oid)
where oprname='<->';

Regards,
Tomasz Myrta