Mercurial > urweb

comparison doc/manual.tex @ 1543:6f046b4bad24

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add antiquote for ORDER BY directions
author Adam Chlipala <adam@chlipala.net>
date Fri, 19 Aug 2011 14:20:24 -0400
parents 7ef09e91198b
children a99b743a3087
comparison
equal deleted inserted replaced
1542:dc4c61363d0a 1543:6f046b4bad24
2098 &&& (E) & \textrm{explicit precedence} \\ 2098 &&& (E) & \textrm{explicit precedence} \\
2099 \textrm{Nullary operators} & n &::=& \mt{CURRENT\_TIMESTAMP} \\ 2099 \textrm{Nullary operators} & n &::=& \mt{CURRENT\_TIMESTAMP} \\
2100 \textrm{Unary operators} & u &::=& \mt{NOT} \\ 2100 \textrm{Unary operators} & u &::=& \mt{NOT} \\
2101 \textrm{Binary operators} & b &::=& \mt{AND} \mid \mt{OR} \mid \neq \mid < \mid \leq \mid > \mid \geq \\ 2101 \textrm{Binary operators} & b &::=& \mt{AND} \mid \mt{OR} \mid \neq \mid < \mid \leq \mid > \mid \geq \\
2102 \textrm{Aggregate functions} & a &::=& \mt{COUNT} \mid \mt{AVG} \mid \mt{SUM} \mid \mt{MIN} \mid \mt{MAX} \\ 2102 \textrm{Aggregate functions} & a &::=& \mt{COUNT} \mid \mt{AVG} \mid \mt{SUM} \mid \mt{MIN} \mid \mt{MAX} \\
2103 \textrm{Directions} & o &::=& \mt{ASC} \mid \mt{DESC} \\ 2103 \textrm{Directions} & o &::=& \mt{ASC} \mid \mt{DESC} \mid \{e\} \\
2104 \textrm{SQL integer} & N &::=& n \mid \{e\} \\ 2104 \textrm{SQL integer} & N &::=& n \mid \{e\} \\
2105 \end{array}$$ 2105 \end{array}$$
2106 2106
2107 Additionally, an SQL expression may be inserted into normal Ur code with the syntax $(\mt{SQL} \; E)$ or $(\mt{WHERE} \; E)$. Similar shorthands exist for other nonterminals, with the prefix $\mt{FROM}$ for $\mt{FROM}$ items and $\mt{SELECT1}$ for pre-queries. 2107 Additionally, an SQL expression may be inserted into normal Ur code with the syntax $(\mt{SQL} \; E)$ or $(\mt{WHERE} \; E)$. Similar shorthands exist for other nonterminals, with the prefix $\mt{FROM}$ for $\mt{FROM}$ items and $\mt{SELECT1}$ for pre-queries.
2108 2108