Mercurial > urweb
comparison doc/manual.tex @ 2169:3acaaff30c85
Add LIKE to the manual
author | Adam Chlipala <adam@chlipala.net> |
---|---|
date | Sat, 15 Aug 2015 08:10:20 -0400 |
parents | 7ce804ecd56b |
children | cf2abef213d8 |
comparison
equal
deleted
inserted
replaced
2168:544199d8b14a | 2169:3acaaff30c85 |
---|---|
2312 &&& \mt{IF} \; E \; \mt{THEN} \; E \; \mt{ELSE} \; E & \textrm{conditional} \\ | 2312 &&& \mt{IF} \; E \; \mt{THEN} \; E \; \mt{ELSE} \; E & \textrm{conditional} \\ |
2313 &&& (Q) & \textrm{subquery (must return a single expression column)} \\ | 2313 &&& (Q) & \textrm{subquery (must return a single expression column)} \\ |
2314 &&& (E) & \textrm{explicit precedence} \\ | 2314 &&& (E) & \textrm{explicit precedence} \\ |
2315 \textrm{Nullary operators} & n &::=& \mt{CURRENT\_TIMESTAMP} \\ | 2315 \textrm{Nullary operators} & n &::=& \mt{CURRENT\_TIMESTAMP} \\ |
2316 \textrm{Unary operators} & u &::=& \mt{NOT} \\ | 2316 \textrm{Unary operators} & u &::=& \mt{NOT} \\ |
2317 \textrm{Binary operators} & b &::=& \mt{AND} \mid \mt{OR} \mid = \mid \neq \mid < \mid \leq \mid > \mid \geq \\ | 2317 \textrm{Binary operators} & b &::=& \mt{AND} \mid \mt{OR} \mid = \mid \neq \mid < \mid \leq \mid > \mid \geq \mid \mt{LIKE} \\ |
2318 \textrm{Aggregate functions} & a &::=& \mt{COUNT} \mid \mt{AVG} \mid \mt{SUM} \mid \mt{MIN} \mid \mt{MAX} \\ | 2318 \textrm{Aggregate functions} & a &::=& \mt{COUNT} \mid \mt{AVG} \mid \mt{SUM} \mid \mt{MIN} \mid \mt{MAX} \\ |
2319 \textrm{Directions} & o &::=& \mt{ASC} \mid \mt{DESC} \mid \{e\} \\ | 2319 \textrm{Directions} & o &::=& \mt{ASC} \mid \mt{DESC} \mid \{e\} \\ |
2320 \textrm{SQL integer} & N &::=& n \mid \{e\} \\ | 2320 \textrm{SQL integer} & N &::=& n \mid \{e\} \\ |
2321 \textrm{Windowable expressions} & \hat{E} &::=& E \\ | 2321 \textrm{Windowable expressions} & \hat{E} &::=& E \\ |
2322 &&& w \; [\mt{OVER} \; ( & \textrm{(Postgres only)} \\ | 2322 &&& w \; [\mt{OVER} \; ( & \textrm{(Postgres only)} \\ |