diff options
| author |  Adam Chlipala <adam@chlipala.net> | 2012-06-02 16:00:50 -0400 |
|---|---|---|
| committer | Adam Chlipala <adam@chlipala.net> | 2012-06-02 16:00:50 -0400 |
| commit | 8b6941ac380392e36a30a06fb558c47a8fe7d2d8 (patch) | |
| tree | da888caf3fa14afe2943de2d9c8c82830c209de1 /tests/window.ur | |
| parent | f4dab2b31d11cc6957c1a64a3ffe6261816d96d4 (diff) | |
Compiled a window function use
Diffstat (limited to 'tests/window.ur')
| -rw-r--r-- | tests/window.ur | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/tests/window.ur b/tests/window.ur new file mode 100644 index 00000000..fd93679c --- /dev/null +++ b/tests/window.ur @@ -0,0 +1,11 @@ +table empsalary : { Depname : string, + Empno : int, + Salary : int } + +fun main () : transaction page = + x <- queryX (SELECT empsalary.Depname, empsalary.Empno, empsalary.Salary, RANK() AS R + FROM empsalary) + (fn r => <xml>{[r.Empsalary.Depname]}, {[r.Empsalary.Empno]}, {[r.Empsalary.Salary]}, {[r.R]}<br/></xml>); + return <xml><body> + {x} + </body></xml> |