Skip to content

Accessing previous rows (LAG/LEAD - window function style) #5485

@svladykin

Description

@svladykin

As far as I see currently there is no way to access previous rows like lag window function in SQL? https://www.postgresql.org/docs/11/functions-window.html

Still, the function runningAccumulate accesses the values from the previous rows (only within a single Block??).
Looks like it must be relatively easy to implement function runningLag the same way?

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions