Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 35B37476048 for ; Thu, 12 Sep 2002 15:39:17 -0400 (EDT) Received: from wolff.to (unknown [66.93.197.35]) by postgresql.org (Postfix) with SMTP id 09175475F25 for ; Thu, 12 Sep 2002 15:39:15 -0400 (EDT) Received: (qmail 9982 invoked by uid 500); 12 Sep 2002 19:46:51 -0000 Date: Thu, 12 Sep 2002 14:46:51 -0500 From: Bruno Wolff III To: Larry Rosenman Cc: Tim Perdue , pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] Latitude / Longitude Message-ID: <20020912194651.GA9901@wolff.to> Mail-Followup-To: Larry Rosenman , Tim Perdue , pgsql-general@postgresql.org, pgsql-sql@postgresql.org References: <20020912124426.A27570@mail.perdue.net> <1031852961.380.20.camel@lerlaptop.iadfw.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1031852961.380.20.camel@lerlaptop.iadfw.net> User-Agent: Mutt/1.3.25i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/508 X-Sequence-Number: 30089 On Thu, Sep 12, 2002 at 12:49:21 -0500, Larry Rosenman wrote: > Look at contrib/earthdistance, I **think** it does what you need. There isn't an index for the distance operator. You can use boxes to limit the candidates if there is a small bound on how far apart points can be before they are no longer candidates for a match even if they are a nearest neighbor pair.