view tests/coalesce.ur @ 1983:0ff4f64b4309

Merge in upstream
author Patrick Hurst <phurst@mit.edu>
date Wed, 29 Jan 2014 18:29:43 -0500
parents e44be6ece475
children
line wrap: on
line source
table t : { A : option int }

fun main () : transaction page =
    queryX (SELECT COALESCE(t.A, 13)
            FROM t)
    (fn r => <xml>{[r.1]},</xml>)