Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |
| spec [2012/03/10 15:06] – [Syntax of FwSQL] wuyw | spec [2012/03/10 15:08] (current) – old revision restored wuyw |
|---|
| *//where-condition//::=//bool-expr// | *//where-condition//::=//bool-expr// |
| *//bool-expr// ::=//value cop value// \\ | //bool-expr// AND //bool-expr// \\ | //bool-expr// OR //bool-expr// \\ | [NOT] EXISTS (//subquery//)\\ | //value cop// ANY (//subquery//) \\ | //value// IN (//subquery//) \\ | //value cop// ALL (//subquery//) \\ | (//bool-expr//) | *//bool-expr// ::=//value cop value// \\ | //bool-expr// AND //bool-expr// \\ | //bool-expr// OR //bool-expr// \\ | [NOT] EXISTS (//subquery//)\\ | //value cop// ANY (//subquery//) \\ | //value// IN (//subquery//) \\ | //value cop// ALL (//subquery//) \\ | (//bool-expr//) |
| *//cop// ::= < | > | = | <= | >= | <> | *//cop// ::= < | > | = | ''''<''='' | >= | <> |
| *//value// ::= (//value//)|//col-name//|//const-value//|//value aop value// \\ | (subquery with only one elements(or NULL)in the result table)\\ | //func//(//col-name//) | *//value// ::= (//value//)|//col-name//|//const-value//|//value aop value// \\ | (subquery with only one elements(or NULL)in the result table)\\ | //func//(//col-name//) |
| *//aop// ::= + | - | * | / | % | *//aop// ::= + | - | * | / | % |
