| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Ryan Orth <ryan(at)seahat(dot)com>, jeff(at)propertykey(dot)com |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: nearest match |
| Date: | 2003-03-14 05:18:37 |
| Message-ID: | 24770000.1047619117@lerlaptop.lerctr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
--On Thursday, March 13, 2003 11:22:21 -0600 Ryan Orth <ryan(at)seahat(dot)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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomasz Myrta | 2003-03-14 07:56:31 | Re: displaying correct name |
| Previous Message | Bruce Young | 2003-03-14 03:11:28 | displaying correct name |