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

From Tomasz Myrta
Subject Re: point <-> polygon not supported?
Date
Msg-id 3E550AF6.6060203@klaster.net
Whole thread Raw
In response to Re: point <-> polygon not supported?  ("Scott Ding" <scott.ding@autodesk.com>)
List pgsql-sql
Scott Ding wrote:
> 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.
I have never user geometric types...
I think, you can use some data type, which can be used for counting 
distance, for example circle:

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

Regards,
Tomasz Myrta



pgsql-sql by date:

Previous
From: "Scott Ding"
Date:
Subject: Re: point <-> polygon not supported?
Next
From: "Scott Ding"
Date:
Subject: Re: point <-> polygon not supported?