slick-pg icon indicating copy to clipboard operation
slick-pg copied to clipboard

Add support for SUM window functions in slick-pg

Open maximmold opened this issue 6 years ago • 2 comments

We would like to be able to use the sum window function documented here.

e.g. SELECT salary, sum(salary) OVER (ORDER BY salary) FROM empsalary;

maximmold avatar Dec 21 '18 14:12 maximmold

It's supported, you can check here for test cases.

tminglei avatar Dec 23 '18 11:12 tminglei

See this unit test in particular, which shows windowing using avg: https://github.com/tminglei/slick-pg/blob/868f3666197ff3a0a1f233c2a9905feb483551f4/core/src/test/scala/com/github/tminglei/slickpg/PgWindowFuncCoreSuite.scala#L52

evbo avatar Aug 21 '19 17:08 evbo