Re: nearest match - Mailing list pgsql-sql

From Larry Rosenman
Subject Re: nearest match
Date
Msg-id 24770000.1047619117@lerlaptop.lerctr.org
Whole thread Raw
In response to Re: nearest match  ("Ryan Orth" <ryan@seahat.com>)
List pgsql-sql

--On Thursday, March 13, 2003 11:22:21 -0600 Ryan Orth <ryan@seahat.com> 
wrote:

>> Ryan wrote:

> Hot damn! thats exactly what I needed.  I imagine I would only be
> comparing the distance of 50 points at any given time (about the max
> number of reference numbers on any given image) so its mighty quick.
> (184 points takes 1.80 msec to check)
>
> I didn't even know about those geometric operators (I find new stuff every
> day I swear).   Are they SQL standard or postgres specific?
postgres specific.  There are a WHOLE bunch of geometric operators and 
functions
in PG.

LER



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749





pgsql-sql by date:

Previous
From: "Len Morgan"
Date:
Subject: Re: What's wrong with this group by clause?
Next
From: Tomasz Myrta
Date:
Subject: Re: displaying correct name