Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Invalid
-
3.1.0
-
None
-
None
Description
Currently, looks like some queries does not works if both, a range frame and a row frame are given. However, PgSQL is able to handle them:
select last(salary) over(order by enroll_date range between 1 preceding and 1 following), lag(salary) over(order by enroll_date range between 1 preceding and 1 following), salary, enroll_date from empsalary;