f_rrd_id = 444) FiveM
ON (OneM.f_timestamp = FiveM.f_timestamp)
where OneM.f_rrd_id = 444
ORDER BY OneM.f_timestamp;
From: Justin
To: Kashmir
Cc: pgsql-sql@postgresql.org
Sent: Wednesday, April 8, 2009 9:38:22 PM
Subject: Re: [SQL] join help
Kashmir
Kashmir wrote:only difference is:
first table stores data per 'f_rrd_id' evey 5min, and the second table every single minute.
I
want to run a query that would return for the same 'f_rrd_id' all
values from both tables sorted by f_timestamp, of course a set would
only have values from the 5m
i'm in need of some psql advise,
believe its rather a trivial issue, but confusing for me...
facing following issue:
got 2 tables like:
CREATE TABLE td_fetch_by_rrd_id (
f_rrd_id numeric NOT NULL,
f_timestamp numeric NOT NULL,
f_ds numeric,
f_us numeric,
CONSTRAINT td_fetch_by_rrd_id_p
First off, thanks for taking the time to read this and try to assist.
I have 3 tables: assets,polls,aps
-Assets is a master list of all of the wireless assets in our
environment.
-Polls is an ongoing table containing data from a script that logs
into 140 AP's every hour on the hour and retrives
