Re: haversine formula with postgreSQL

On Thu, Sep 17, 2009 at 8:37 PM, Jonathan Harahush <jharahush(at)gmail(dot)com> wrote:
> I do have PostGIS installed and I use it for other things (geoserver), but
> I'm not knowledgeable enough about it to the point where I understand how to
> get it to work with the Google Maps API.  I'll look into it.  In the
> meantime, I was hoping to create something based off of the GMaps/PHP/MySQL
> example I referenced in an earlier post since I'm still learning.
> The reason why I'm using Postgres is because it's installed at work.  We
> don't use MySQL.
>
> Thanks for all of the help so far!  I appreciate it.

The good news is that while postgresql is more persnickity about SQL
standards and it feels like you're dealing with a harsh task master,
the lessons learned are good ones. They'll translate to other
database engines, and in the future when mysql grows more standards
compliant too.