Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- t.i AS when_ts,
- VALUE
- FROM
- generate_series(
- ( SELECT date_trunc('second', MIN("timestamp")) FROM DATA),
- ( SELECT date_trunc('second', MAX("timestamp")) FROM DATA),
- '1 second'::INTERVAL
- ) AS t (i)
- LEFT OUTER JOIN DATA d ON t.i = date_trunc( 'second', d."timestamp")
- ORDER BY when_ts;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement