Re: point <-> polygon not supported?

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Scott Ding <scott(dot)ding(at)autodesk(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: point <-> polygon not supported?
Date: 2003-02-20 14:55:20
Message-ID: 3E54EC58.7090605@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-02-20 15:13:39 Re: problem on truncate for v.7.3.2
Previous Message Stephen.Thompson 2003-02-20 13:45:50 Re: VIEW or Stored Proc - Is this even possible?