annotate tests/lower.ur @ 1636:2b312f6d4007

SQL lower() and upper() functions
author Adam Chlipala <adam@chlipala.net>
date Sat, 17 Dec 2011 12:01:31 -0500
parents
children
rev   line source
adam@1636 1 table lower : { A : string }
adam@1636 2
adam@1636 3 fun main () : transaction page =
adam@1636 4 all <- queryX1 (SELECT *
adam@1636 5 FROM lower
adam@1636 6 WHERE lower(lower.A) LIKE '%foo')
adam@1636 7 (fn r => <xml>{[r.A]}<br/></xml>);
adam@1636 8 return <xml><body>
adam@1636 9 {all}
adam@1636 10 </body></xml>