[postgis-users] help with distance query

[mark balman]

Hi all

I am trying to work out how to return the distances from a user
defined location but not too sure how. My query follows;

select * from azev2_1 where distance_spheroid(GeomFromText('Point(-70
20)',4326),the_geom,'SPHEROID["WGS 84",6378137,298.257223563]') <
250000;

This provides all the point features located within 250000 metres of
the coordinates -70, 20 but how do I return the distances that each
feature is away from those coordinates?

Any ideas would be much appreciated.

Many thanks

Mark