--- On Thu, 10/8/09, sub3 wrote:
From: sub3
Subject: [SQL] Pulling additional columns with aggregate
To: pgsql-sql@postgresql.org
Date: Thursday, October 8, 2009, 1:14 PM
Hi,
I have 2 tables. I want to be able to calculate the closest value in one
(tempvalues), to the closest value in the
Hi,
I have 2 tables. I want to be able to calculate the closest value in one
(tempvalues), to the closest value in the other (points). This closest
point, I want to save into the table with its difference.
So if I have:
create table points (
id integer,
center double precision
);
insert i
