Re: nearest neighbor search from xyz coordinates

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Andreas Jochem" <andruit(at)gmx(dot)de>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: nearest neighbor search from xyz coordinates
Date: 2008-10-28 15:12:41
Message-ID: b42b73150810280812v2db51b3fg8db1f7d9ad9cfcfd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 27, 2008 at 6:50 AM, Andreas Jochem <andruit(at)gmx(dot)de> wrote:
> Hello,
>
> I have a table containing x y z coordinates. But I have no geometry column?
> Is it possible to find the k nearest neighbors of any point. Is there
> something like a kd-tree Index in postgres???
>

cubes:
http://www.postgresql.org/docs/8.3/interactive/cube.html

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2008-10-28 15:36:29 Re: [Help] Config Failure on Mac OSX: psqlodbc-08.03.0300
Previous Message Vincas Dargis 2008-10-28 15:02:33 Re: regexp_replace - replace non-numbers