Thanks for your reply, i am totally new to Postgis. we have Database, but not ready for Geocode use. what i understood from different blog, we should have latitude and longitude either based on addresses, or postal code we have. However if I will get the lat and long, need to calculate earth distance to give location based on user location. Formula i got, is calculating shortest distance, which always not true practically. Please address my concern, how i will get rid of these issues.
Regards, Itishree On Wed, Jan 15, 2014 at 11:28 PM, Oleg Bartunov <obartu...@gmail.com> wrote: > check knn search, > http://www.sai.msu.su/~megera/postgres/talks/pgcon-2010-1.pdf > > On Wed, Jan 15, 2014 at 8:04 PM, itishree sukla > <itishree.su...@gmail.com> wrote: > > Deal all, > > > > In my project, there is a requirement to implement proximity search > feature. > > We are running a mobile app, for which proximity search is require. Can > any > > one guide me how i can achieve this using postgis, or is there any other > way > > i can achieve this. > > > > We are using postgresql 9.2. > > > > Thanks in advance . > > > > Regards, > > Itishree >