Mercurial > urweb
view tests/query.ur @ 1168:69f1d39d3f2d
Use COALESCE to hide NULL results of aggregate functions; fix bug with improper ordering of query result columns
author | Adam Chlipala <adamc@hcoop.net> |
---|---|
date | Thu, 25 Feb 2010 14:55:35 -0500 |
parents | 5f9b9972e6b8 |
children |
line wrap: on
line source
table t1 : {A : int, B : string, C : float, D : bool} table t2 : {A : float, D : int} datatype list a = Nil | Cons of a * list a val q1 = (SELECT * FROM t1) val r1 : transaction (list {A : int, B : string, C : float, D : bool}) = query q1 (fn fs acc => return (Cons (fs.T1, acc))) Nil val r2 : transaction string = ls <- r1; return (case ls of Nil => "Problem" | Cons ({B = b, ...}, _) => b) fun main () : transaction page = s <- r2; return <xml><body> {cdata s} </body></xml>