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@klaster.net]
Sent: Thursday, February 20, 2003 6:55 AM
To: Scott Ding
Cc: pgsql-sql@postgresql.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@postgresql.org)