Re: haversine formula with postgreSQL - Mailing list pgsql-general

From Scott Marlowe
Subject Re: haversine formula with postgreSQL
Date
Msg-id dcc563d10909172035j3276e297mf31cfd772e34dace@mail.gmail.com
Whole thread Raw
In response to Re: haversine formula with postgreSQL  (Jonathan Harahush <jharahush@gmail.com>)
List pgsql-general
On Thu, Sep 17, 2009 at 8:37 PM, Jonathan Harahush <jharahush@gmail.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.

pgsql-general by date:

Previous
From: Jonathan Harahush
Date:
Subject: Re: haversine formula with postgreSQL
Next
From: "Johnson, Trevor"
Date:
Subject: PostgreSQL nonstandard use of escape in a string literal