Mercurial > urweb

annotate tests/sql_if.ur @ 1775:6bc2a8cb3a67

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Track whether SQL expressions may use window functions, in preparation for actual window function support
author Adam Chlipala <adam@chlipala.net>
date Sat, 02 Jun 2012 15:35:58 -0400
parents 34364e383bed
children
rev   line source
adam@1573 1 table t : { A : int, B : int }
adam@1573 2
adam@1573 3 fun main () =
adam@1573 4 x <- queryX (SELECT * FROM t WHERE IF t.A = 6 THEN t.B < 2 ELSE t.B > 5)
adam@1573 5 (fn r => <xml><li>{[r.T.A]}, {[r.T.B]}</li></xml>);
adam@1573 6 return <xml><body>{x}</body></xml>