Advertisement
Guest User

stat_300_40000_1 query

a guest
Apr 16th, 2014
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.35 KB | None | 0 0
  1. INSERT INTO stat_300_40000_1(ts, target, port, DATA)SELECT DISTINCT timestamp-(TIMESTAMP %3600) AS wide_row_ts, target, subclass_id AS port, array[]::REAL[] AS DATA FROM write_300_temp AS temp WHERE class_id=40000 AND n
  2. ot EXISTS (SELECT ts FROM stat_300_40000_1 WHERE ts=temp.timestamp-(temp.timestamp%3600) AND target=temp.target AND port=temp.subclass_id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement