Mercurial > urweb

view tests/sql_if.ur @ 1636:2b312f6d4007

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SQL lower() and upper() functions
author Adam Chlipala <adam@chlipala.net>
date Sat, 17 Dec 2011 12:01:31 -0500
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>