Mercurial > urweb

annotate tests/sql_ops.ur @ 1394:d328983dc5a6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Allow subqueries to reference aggregate-only columns of free tables; treat non-COUNT aggregate functions as possibly returning NULL
author Adam Chlipala <adam@chlipala.net>
date Sat, 15 Jan 2011 14:53:13 -0500
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