annotate tests/coalesce.ur @ 1810:b8558b613abd

show_sql_query
author Adam Chlipala <adam@chlipala.net>
date Wed, 22 Aug 2012 08:46:32 -0400
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>)