Mercurial > urweb

annotate tests/sql_if.ur @ 1867:216a3a67ebe3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Tweak Sergey's patch to work with Postgres
author Adam Chlipala <adam@chlipala.net>
date Fri, 13 Sep 2013 10:24:10 -0400
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>