Nearest places from a certain point

Question

I have the following table

create table places(lat_lng point, place_name varchar(50));

insert into places values (POINT(-126.4, 45.32), 'Food Bar');

What should be the query to get all places close to particular lat/long?

gis is installed.

Answer 1

select *
from places
where lat_lng <-> POINT(-125.4, 46.32) < 1
order by lat_lng <-> POINT(-125.4, 46.32)