Mercurial > urweb
annotate tests/filter.ur @ 1564:da11f7b18067
Add an URWEB_PQ_CON environment variable, which overrides the PostgreSQL connection string.
| author | Austin Seipp <as@hacks.yi.org> |
|---|---|
| date | Fri, 23 Sep 2011 23:11:59 -0500 |
| parents | 6d9538ce94d8 |
| children |
| rev | line source |
|---|---|
| adamc@904 | 1 fun filter [fs ::: {Type}] [ks] (t : sql_table fs ks) (p : sql_exp [T = fs] [] [] bool) |
| adamc@904 | 2 : sql_query [T = fs] [] = |
| adamc@904 | 3 (SELECT * FROM t WHERE {p}) |
| adamc@904 | 4 |
| adamc@904 | 5 table t : { A : int, B : float } |
| adamc@904 | 6 |
| adamc@904 | 7 fun main () = |
| adamc@904 | 8 queryX (filter t (WHERE t.A > 3)) |
| adamc@904 | 9 (fn r => <xml>{[r.T.A]}, {[r.T.B]}</xml>) |