Mercurial > urweb
annotate tests/fitem.ur @ 1607:da788bd72c9e
Add LIKE operator to SQL sublanguage.
author | Karn Kallio <kkallio@eka> |
---|---|
date | Wed, 23 Nov 2011 13:17:40 -0430 |
parents | e8d68fd8ed4b |
children |
rev | line source |
---|---|
adamc@1265 | 1 table t : { A : int, B : string } |
adamc@1265 | 2 table u : { A : int, C : float } |
adamc@1265 | 3 |
adamc@1265 | 4 val q : sql_query [] [T = [A = int, B = string], U = [C = option float]] [] = |
adamc@1265 | 5 (SELECT t.A, t.B, u.C |
adamc@1265 | 6 FROM {{sql_left_join (FROM t) (FROM u) (WHERE TRUE)}}) |