summaryrefslogtreecommitdiff
path: root/tests/time.ur
diff options
context:
space:
mode:
authorGravatar Adam Chlipala <adamc@hcoop.net>2008-10-30 15:16:37 -0400
committerGravatar Adam Chlipala <adamc@hcoop.net>2008-10-30 15:16:37 -0400
commit7e90e2dd45c936519b6397a3ac9f8cb481ea6511 (patch)
treefe9ae1798baecaadf006b54d792997b0fb2db54c /tests/time.ur
parent5421d219d4b51b4b8ef18524d5b7db5c4939c36d (diff)
Time MIN/MAX
Diffstat (limited to 'tests/time.ur')
-rw-r--r--tests/time.ur4
1 files changed, 3 insertions, 1 deletions
diff --git a/tests/time.ur b/tests/time.ur
index f66004a5..f81c59c3 100644
--- a/tests/time.ur
+++ b/tests/time.ur
@@ -7,7 +7,9 @@ fun main () =
dml (INSERT INTO t (Id, Time) VALUES (42, {now}));
xml <- queryX (SELECT * FROM t)
(fn r => <xml>{[r.T.Id]}: {[r.T.Time]}<br/></xml>);
+ minMax <- oneRow (SELECT MIN(t.Time) AS Min, MAX(t.Time) AS Max FROM t);
return <xml><body>
{xml}
- {[now]}, {[now = now]}, {[now = later]}, {[later < now]}, {[now < later]}
+ {[now]}, {[now = now]}, {[now = later]}, {[later < now]}, {[now < later]}<br/>
+ {[minMax.Min]}, {[minMax.Max]}
</body></xml>