view tests/selclause.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 5c1f10cdac63
children
line wrap: on
line source
table t : { A : int, B : string, C : float }
table u : { D : int, E : string, F : float }

val q : transaction (list {T : { A : int, B : string, C : float}, U : { D : int }, X : string }) =
    queryL (SELECT t.*, u.D, 'hi' AS X
            FROM t, u)