Mercurial > urweb

annotate tests/sql_if.ur @ 1607:da788bd72c9e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add LIKE operator to SQL sublanguage.
author Karn Kallio <kkallio@eka>
date Wed, 23 Nov 2011 13:17:40 -0430
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>