Mercurial > urweb
annotate tests/timestamp.ur @ 1866:9fc086e3c95a
Add hex SQL syntax for blobs, such as X'0ABC12343'. Works with sqlite.
| author | Sergey Mironov <grrwlf@gmail.com> |
|---|---|
| date | Fri, 13 Sep 2013 10:09:15 -0400 |
| parents | 690638bd9fef |
| children |
| rev | line source |
|---|---|
| adam@1834 | 1 table t : { A : time } |
| adam@1834 | 2 |
| adam@1834 | 3 fun many ls = |
| adam@1834 | 4 case ls of |
| adam@1834 | 5 [] => (WHERE TRUE) |
| adam@1834 | 6 | tm :: ls' => (WHERE t.A = {[tm]} AND {many ls'}) |
| adam@1834 | 7 |
| adam@1834 | 8 task initialize = fn () => |
| adam@1834 | 9 tm <- now; |
| adam@1834 | 10 dml (DELETE FROM t WHERE {many (tm :: [])}) |
| adam@1834 | 11 |