view tests/coalesce.ur @ 1977:50322ba22972

Add datetime functions for adding time intervals.
author Patrick Hurst <phurst@mit.edu>
date Mon, 09 Dec 2013 19:19:12 -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>)