annotate tests/view.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 8688e01ae469
children
rev   line source
adamc@754 1 table t : { A : int, B : string }
adamc@754 2
adamc@754 3 view v = SELECT t.A AS X FROM t
adamc@754 4
adamc@754 5 fun main () =
adamc@754 6 rows <- queryX (SELECT * FROM v)
adamc@754 7 (fn r => <xml><li>{[r.V.X]}</li></xml>);
adamc@754 8 return <xml><body>
adamc@754 9 {rows}
adamc@754 10 </body></xml>