我有一个关于timescaledb的函数time_bucket_gapfill问题,当我设置一个初始值,想要查询自这天以后7天的数据,但是timescaledb总是从周一开始计算.我该如何自定义七天的范围?
难道只能查询出每天的范围,然后依照规则计算七天的数据吗?
由于声望值不够,只能在postgreSql标签下提问
SELECT
time_bucket_gapfill('7 day', time,
start =>'2016-01-02',finish => '2016-12-31') AS "day",
locf(sum(pub_flg)) as pub_flg
FROM public.tb_lp_media_pub
where media_id=3236
GROUP BY "day"
ORDER BY "day" asc;