view 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
line wrap: on
line source
table t : { A : time }

fun many ls =
    case ls of
        [] => (WHERE TRUE)
      | tm :: ls' => (WHERE t.A = {[tm]} AND {many ls'})

task initialize = fn () =>
                     tm <- now;
                     dml (DELETE FROM t WHERE {many (tm :: [])})