Mercurial > urweb

annotate tests/coalesce.ur @ 2289:78820fa8f5a7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix bugs for lock calculation and SQL parsing and add support for tasks.
author Ziv Scully <ziv@mit.edu>
date Sun, 15 Nov 2015 14:18:35 -0500
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>)