| (:********************************************************************:) | |
| (: Test: function-declaration-004.xq :) | |
| (: Written By: Pulkita Tyagi :) | |
| (: Date: Thu Jun 2 00:24:56 2005 :) | |
| (: Purpose: Demonstrate function declaration in different combination :) | |
| (:********************************************************************:) | |
| (: insert-start :) | |
| declare variable $input-context external; | |
| (: insert-end :) | |
| declare function local:summary($emps as element(employee)*) | |
| as element(dept)* | |
| { | |
| for $d in distinct-values($emps/deptno) | |
| let $e := $emps[deptno = $d] | |
| return | |
| <dept> | |
| <deptno>{$d}</deptno> | |
| <headcount> {count($e)} </headcount> | |
| <payroll> {sum($e/salary)} </payroll> | |
| </dept> | |
| }; | |
| local:summary($input-context//employee[location = "Denver"]) |