Home > mailing lists

Re: locating cities within a radius of another - Mailing list pgsql-general

From	Oliver Kohll - Mailing Lists
Subject	Re: locating cities within a radius of another
Date	July 22, 2010 09:22:42
Msg-id	46CE156D-001C-4F25-ABEC-6CC5AD9A4BBD@gtwm.co.uk Whole thread Raw
In response to	locating cities within a radius of another (Geoffrey <lists@serioustechnology.com>)
Responses	Re: locating cities within a radius of another (Geoffrey <lists@serioustechnology.com>) Re: locating cities within a radius of another (Geoffrey <lists@serioustechnology.com>) Re: locating cities within a radius of another (Geoffrey <lists@serioustechnology.com>)
List	pgsql-general

On 21 Jul 2010, at 23:14, Joe Conway <mail@joeconway.com> wrote:

If you want something simple, and not requiring PostGIS, but plpgsql
instead, see:

http://archives.postgresql.org/pgsql-sql/2003-12/msg00193.php

For completeness, the earthdistance module also provides the distance between two lat/longs, the point<@>point syntax is simple to use:

Regards

Oliver Kohll

From: Magnus Hagander
Date: 22 July 2010, 08:56:40
Subject: Re: Passing a PGconn * between two processes on Unix like systems

From: Alban Hertroys
Date: 22 July 2010, 11:11:15
Subject: Re: Passing a PGconn * between two processes on Unix like systems