添加生成的列，并在一个部分上汇总并排序
我正在尝试添加一个计算出的列，该列计算分类分区的滚动平均值。我可以使其作为查询工作，但似乎无法使结果成为一个计算的字段。
ALTER TABLE PUBLIC "minutes"
ADD COLUMN "green_avg" NUMERIC (10,2)
AS GENERATED AVG("price") OVER(PARTITION BY "key"
ORDER BY "endtime" ROWS BETWEEN 30 PRECEDING AND CURRENT ROW)
I am trying to add a calculated column that computes a rolling average of a sorted partition. I can make it work as a query but cannot seem to get the result to become a calculated field.
ALTER TABLE PUBLIC "minutes"
ADD COLUMN "green_avg" NUMERIC (10,2)
AS GENERATED AVG("price") OVER(PARTITION BY "key"
ORDER BY "endtime" ROWS BETWEEN 30 PRECEDING AND CURRENT ROW)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论