Mercurial > urweb

view tests/sql_ops.ur @ 1466:e2d7bd41f527

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remember to remove explicit table projections in SQLite UPDATE SET values
author Adam Chlipala <adam@chlipala.net>
date Mon, 30 May 2011 07:48:08 -0400
parents 5d494183ca89
children
line wrap: on
line source
table t : { A : int, B : float }

val q = (SELECT t.A + t.A AS X, t.B * t.B AS Y FROM t)

fun main () : transaction page =
    xml <- queryX q (fn r => <xml>{[r.X]}, {[r.Y]}<br/></xml>);
    return <xml><body>{xml}</body></xml>