Mercurial > urweb
annotate tests/sql_ops.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 | 5d494183ca89 |
| children |
| rev | line source |
|---|---|
| adamc@559 | 1 table t : { A : int, B : float } |
| adamc@559 | 2 |
| adamc@559 | 3 val q = (SELECT t.A + t.A AS X, t.B * t.B AS Y FROM t) |
| adamc@559 | 4 |
| adamc@559 | 5 fun main () : transaction page = |
| adamc@559 | 6 xml <- queryX q (fn r => <xml>{[r.X]}, {[r.Y]}<br/></xml>); |
| adamc@559 | 7 return <xml><body>{xml}</body></xml> |
| adamc@559 | 8 |