diff options
author | Adam Chlipala <adamc@hcoop.net> | 2010-03-25 15:44:24 -0400 |
---|---|---|
committer | Adam Chlipala <adamc@hcoop.net> | 2010-03-25 15:44:24 -0400 |
commit | 26eeffeaee9f015cc95430da2f5308ce585a194d (patch) | |
tree | dec271c0511b398d8701237909469ed5be9dca5b /tests/subquery.ur | |
parent | 66e0340c72d73b437c0f004fbcefc52a2c2e10a8 (diff) |
Subquery expressions
Diffstat (limited to 'tests/subquery.ur')
-rw-r--r-- | tests/subquery.ur | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/tests/subquery.ur b/tests/subquery.ur new file mode 100644 index 00000000..302175e5 --- /dev/null +++ b/tests/subquery.ur @@ -0,0 +1,10 @@ +table t : { A : int, B : int, C : int } + +fun main () = + v <- queryX1 (SELECT t.A, t.C + FROM t + WHERE t.B = (SELECT MAX(U.B) AS M + FROM t AS U + WHERE U.A = t.A)) + (fn r => <xml>{[r.A]},{[r.C]};</xml>); + return <xml>{v}</xml> |