The ## operator is for finding the closest point to one geometric
object from another (e.g., point ## lseg), not for searching an
entire table. In this example you'll have to calculate the distance
to each point and order the results by it:
SELECT position, position <-> '55.4,-6.4'::point AS dis
On Wed, Oct 05, 2005 at 06:46:16PM +0200, Poul Møller Hansen wrote:
> I have made the table shown below and inserted two points,
> but I can't find the proper syntax for finding the nearest point
>
> create table store_point(position point);
> insert into store_point values ('55.512345, -6.5')
I have made the table shown below and inserted two points,
but I can't find the proper syntax for finding the nearest point
create table store_point(position point);
insert into store_point values ('55.512345, -6.5');
insert into store_point values ('55.123456, -6.1');
select * from store
