[postgis-users] distance beetween the 2 nearest pointsMardi

[cyril coeurjoly]

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