diff options
| author |  Adam Chlipala <adam@chlipala.net> | 2011-11-19 10:43:57 -0500 |
|---|---|---|
| committer | Adam Chlipala <adam@chlipala.net> | 2011-11-19 10:43:57 -0500 |
| commit | e43dd849a122a59fa2c22278ddf9c9a09d1550bd (patch) | |
| tree | b8e125a96ec1466c542b24651ef1ce4027f21193 /tests | |
| parent | 9a047b4f248ace0615eaf18ba130e14e49634723 (diff) | |
COALESCE
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/coalesce.ur | 6 | ||||
| -rw-r--r-- | tests/coalesce.urp | 4 |
2 files changed, 10 insertions, 0 deletions
diff --git a/tests/coalesce.ur b/tests/coalesce.ur new file mode 100644 index 00000000..5ee8cf19 --- /dev/null +++ b/tests/coalesce.ur @@ -0,0 +1,6 @@ +table t : { A : option int } + +fun main () : transaction page = + queryX (SELECT COALESCE(t.A, 13) + FROM t) + (fn r => <xml>{[r.1]},</xml>) diff --git a/tests/coalesce.urp b/tests/coalesce.urp new file mode 100644 index 00000000..7d7decee --- /dev/null +++ b/tests/coalesce.urp @@ -0,0 +1,4 @@ +database dbname=test +sql coalesce.sql + +coalesce |