Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
<SQL terminal character> ::= <SQL language character>
<SQL language character> ::= <simple Latin letter>
| <digit>
| <SQL special character>
<simple Latin letter> ::= <simple Latin upper case letter>

                           | <simple Latin lower case letter>
<simple Latin upper case letter> ::=
       A | B | C | D | E | F | G | H | I | J | K | L | M | N | O
       | P | Q | R | S | T | U | V | W | X | Y | Z
<simple Latin lower case letter> ::=
       a | b | c | d | e | f | g | h | i | j | k | l | m | n | o
       | p | q | r | s | t | u | v | w | x | y | z
<digit> ::=
       0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
<SQL special character> ::= <space>
                           | <double quote>
                           | <percent>
                           | <ampersand>
                           | <quote>
                           | <left paren>
                           | <right paren>
                           | <asterisk>
                           | <plus sign>
                           | <comma>
                           | <minus sign>
                           | <period>
                           | <solidus>
                           | <colon>
                           | <semicolon>
                           | <less than operator>
                           | <equals operator>
                           | <greater than operator>
                           | <question mark>
                           | <left bracket>
                           | <right bracket>
                           | <circumflex>
                           | <underscore>
                           | <vertical bar>
                           | <left brace>
                           | <right brace>
<space> ::= /*space character in character set in use
              In ASCII it would be 40*/
<double quote> ::= "
<percent> ::= %
<ampersand> ::= &
<quote> ::= '
<left paren> ::= (
<right paren> ::= )
<asterisk> ::= *
<plus sign> ::= +
<comma> ::= ,
<minus sign> ::= -
<period> ::= .
<solidus> ::= /
<colon> ::= :
<semicolon> ::= ;
<less than operator> ::= <
<equals operator> ::= =
<greater than operator> ::= >
<question mark> ::= ?
<left bracket> ::= [
<right bracket> ::= ]
<circumflex> ::= ^
<underscore> ::= _
<vertical bar> ::= |
<left brace> ::={
<right brace> ::=}
<separator> ::= { <comment> | <space> | <newline> }...
<token> ::= <nondelimiter token>
            | <delimiter token>
<nondelimiter token> ::= <regular identifier>
                        | <key word>
                        | <unsigned numeric literal>
No Format

<key word> ::= <reserved word>
<reserved word> ::= NOT | AND | OR | LIKE |
                    IS | NULL |
                    EXISTS | DOES-NOT-EXIST |
                    DURING | AFTER | BEFORE
                    IN | INCLUDE | EXCLUDE |
                    TRUE | FALSE |
                    EQUALS | DISJOINT | INTERSECTS | TOUCHES | CROSSES | WITHIN | CONTAINS| OVERLAPS | RELATE | DWITHIN | BEYOND |
                    POINT | LINESTRING | POLYGON | 
                    MULTIPOINT | MULTILINESTRING | MULTIPOLYGON | GEOMETRYCOLLECTION
Numeric
No Format

<unsigned numeric literal> ::= <exact numeric literal>
                              | <approximate numeric literal>
<exact numeric literal> ::=
                <unsigned integer> [<period>[<unsigned integer> ] ]
                | <period> <unsigned integer>
<unsigned integer> ::= <digit>...
<approximate numeric literal> ::= <mantissa> E <exponent>
<mantissa> ::= <exact numeric literal>
<exponent> ::= <signed integer>
<signed integer> ::= [ <sign> ] <unsigned integer>
<sign> ::= <plus sign> | <minus sign>

...