comparison tests/window.ur @ 1778:818d4097e2ed

Lighter-weight encoding of window function use
author Adam Chlipala <adam@chlipala.net>
date Sun, 03 Jun 2012 11:29:31 -0400
parents 59b07fdae1ff
children
comparison
equal deleted inserted replaced
1777:59b07fdae1ff 1778:818d4097e2ed
1 table empsalary : { Depname : string, 1 table empsalary : { Depname : string,
2 Empno : int, 2 Empno : int,
3 Salary : int } 3 Salary : int }
4 4
5 fun main () : transaction page = 5 fun main () : transaction page =
6 x <- queryX (SELECT empsalary.Depname, empsalary.Empno, empsalary.Salary, 6 x <- queryX (SELECT empsalary.Depname, empsalary.Empno, empsalary.Salary,
7 RANK() OVER (PARTITION BY empsalary.Depname ORDER BY empsalary.Salary DESC) AS R, 7 RANK() OVER (PARTITION BY empsalary.Depname ORDER BY empsalary.Salary DESC) AS R,
8 AVG(empsalary.Salary) OVER (PARTITION BY empsalary.Depname) AS A 8 AVG(empsalary.Salary) OVER (PARTITION BY empsalary.Depname) AS A