annotate tests/selclause.ur @ 1982:2b95ecdd94eb
Use localtime, not gmtime, for datetime functions.
author |
Patrick Hurst <phurst@mit.edu> |
date |
Sat, 25 Jan 2014 18:15:14 -0500 |
parents |
5c1f10cdac63 |
children |
|
rev |
line source |
adam@1627
|
1 table t : { A : int, B : string, C : float }
|
adam@1627
|
2 table u : { D : int, E : string, F : float }
|
adam@1627
|
3
|
adam@1627
|
4 val q : transaction (list {T : { A : int, B : string, C : float}, U : { D : int }, X : string }) =
|
adam@1627
|
5 queryL (SELECT t.*, u.D, 'hi' AS X
|
adam@1627
|
6 FROM t, u)
|