Mercurial > urweb

annotate tests/sql_if.ur @ 2294:f8903af753ff

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Support nested queries but disable UrFlow for now.
author Ziv Scully <ziv@mit.edu>
date Thu, 19 Nov 2015 01:59:00 -0500
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>