Re: point <-> polygon not supported?

Tomasz,

Thanks for the tip. What I want to do is something like the following:

Select * from table where (table.geom <-> polygon('((3,3), (3,4), (4,5),
(5,4), (5,3))')) < 1.0);

Table.geom is a point column.

How do I modify your statement to accomplish the above?

Regards,
Scott Ding

-----Original Message-----
From: Tomasz Myrta [mailto:jasiek(at)klaster(dot)net]
Sent: Thursday, February 20, 2003 6:55 AM
To: Scott Ding
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)