Mercurial > urweb

view tests/sql_if.ur @ 1866:9fc086e3c95a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add hex SQL syntax for blobs, such as X'0ABC12343'. Works with sqlite.
author Sergey Mironov <grrwlf@gmail.com>
date Fri, 13 Sep 2013 10:09:15 -0400
parents 34364e383bed
children
line wrap: on
line source
table t : { A : int, B : int }

fun main () =
    x <- queryX (SELECT * FROM t WHERE IF t.A = 6 THEN t.B < 2 ELSE t.B > 5)
                (fn r => <xml><li>{[r.T.A]}, {[r.T.B]}</li></xml>);
    return <xml><body>{x}</body></xml>