Hi, 

I 'm trying to find a way to obtain the distance between two set of geographics 
datas.

I'm using a Postgis database wich contains my two tables. A table of customers 
and a table of stores.

For each customer, i would like to know the 2 nearest stores and the distance 
to theses stores. 

something like :

Mr Smith | 2500 m | Store 3
Mr Smith | 2501 m | Store 4

Mrs Smith | 240 m | Store 1
Mrs Smith | 2501 m | Store 54


thanks a lot.



__________________________________________________
Do You Yahoo!?
En finir avec le spam? Yahoo! Mail vous offre la meilleure protection possible 
contre les messages non sollicités 
http://mail.yahoo.fr Yahoo! Mail

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to