Mercurial > urweb

view tests/sql_if.ur @ 2295:e6c5bb62fef8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix SQL parser JOIN bug and fix ON clause logic in Sqlcache.
author Ziv Scully <ziv@mit.edu>
date Thu, 19 Nov 2015 03:45:39 -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>