--- 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 ot
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
Gary Chambers wrote:
> CREATE OR REPLACE FUNCTION getnote(INTEGER, BIGINT) RETURNS getnote_t AS
> When I call it with a row where n.is_private is TRUE and n.ownerid IS
> TRUE, I receive a single row of all null values:
>
> notesdb=# select * from getnote(1, 2);
> When I submit the query directly
