Mercurial > urweb

annotate tests/coalesce.ur @ 1697:cb0f05bdc183

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Refactor SQL parsing code from Iflow to Sql, add querydml parser.
author Edward Z. Yang <ezyang@mit.edu>
date Mon, 12 Mar 2012 12:00:23 -0700
parents e44be6ece475
children
rev   line source
adam@1602 1 table t : { A : option int }
adam@1602 2
adam@1602 3 fun main () : transaction page =
adam@1602 4 queryX (SELECT COALESCE(t.A, 13)
adam@1602 5 FROM t)
adam@1602 6 (fn r => <xml>{[r.1]},</xml>)