Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- 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