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.55555');
insert into store_point values ('55.123456, -6.11111');
select * from store_point;
position
----------------------
(55.512345,-6.55555)
(55.123456,-6.11111)
I suppose that I should use the ## operator,
but how does it work when I want to find the nearest
row for the points (55.4,-6.4) ?
Thanks,
Poul
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
