Re: point <-> polygon not supported? - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: point <-> polygon not supported?
Date
Msg-id 3E54EC58.7090605@klaster.net
Whole thread Raw
In response to point <-> polygon not supported?  ("Scott Ding" <scott.ding@autodesk.com>)
List pgsql-sql
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




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem on truncate for v.7.3.2
Next
From: "Scott Ding"
Date:
Subject: Re: point <-> polygon not supported?