calculating extent on basis of distance from a given point

From: User Map <map(dot)user(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: calculating extent on basis of distance from a given point
Date: 2008-05-15 11:34:26
Message-ID: 495118.9323.qm@web45705.mail.sp1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
i have OSGB36 data in postgre, srid 27700. what i want to do is to calculate the extent on basis of the distance from a given point. i have geom of type geometry in the table, from which to calculate extent. i have tried the funtions Distance(geom,geom)<50, but it is too slow, as it uses no index. i have calculated the point from the polygon by function Centroid(geom), but i think its not working properly, as i am also testing it with the mapserver map and map saclebar, they are not matching exactly.
the main isuue is of the time the distance query is taking.
is there any why to do this quickly.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-05-15 11:44:50 Re: help
Previous Message Semi Noob 2008-05-15 10:18:25 Re: Need for help!