[postgis-users] help with distance query

[Jean David TECHER]

> Many thanks for your help David, it works!
  :)

select astext(the_geom),  distance_spheroid(GeomFromText('Point(-70
20)',4326),the_geom,'SPHEROID["WGS 84",6378137,298.257223563]'),sitename from
  azev2_1  group  by 1,2,3 having
  distance_spheroid(GeomFromText('Point(-70
  20)',4326),the_geom,'SPHEROID["WGS 84",6378137,298.257223563]') <
  250000;

--david;
===================
Jean David TECHER
www.davidgis.fr
06 60 46 85 05
04 99 77 16 87
===================