File: rdb-queries-results-q11.xq

package info (click to toggle)
qtxmlpatterns-opensource-src 5.15.8-2
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 308,892 kB
  • sloc: xml: 360,343; cpp: 91,994; ansic: 388; sh: 53; sed: 31; makefile: 23
file content (20 lines) | stat: -rw-r--r-- 587 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
(: insert-start :)
declare variable $input-context1 external;
declare variable $input-context2 external;
(: insert-end :)

let $highbid := max($input-context2//bid_tuple/bid)
return
    <result>
     {
        for $item in $input-context1//item_tuple,
            $b in $input-context2//bid_tuple[itemno = $item/itemno]
        where $b/bid = $highbid
        return
            <expensive_item>
                { $item/itemno }
                { $item/description }
                <high_bid>{ $highbid }</high_bid>
            </expensive_item>
     }
    </result>