|
||
data-type
:
BIT
| [ UNSIGNED
] TINYINT
| [ UNSIGNED
] SMALLINT
| [ UNSIGNED
] INTEGER
| COUNTER
| BIGINT
| REAL
| FLOAT
| DOUBLE
[ PRECISION
]
| DATE
| TIME
| TIMESTAMP
| CHAR
[ (
n
)
] | VARCHAR
[ (
n
)
]
| LONG
VARCHAR
| BINARY
[ (
n
)
] | VARBINARY
[ (
n
)
]
| LONG
VARBINARY
date-literal
:
#
{exact date expression}#
Valid date and time expressions are those which can be parsed by the Parse()
member function of the TTime
class.
numeric-literal
:
{exact numeric types}
Valid numeric forms are those which can be parsed by the Val(TInt64&)
and Val(TReal&)
member functions of the TLex
class.
pattern-value
:
string-literal
Non SQL-standard characters in the pattern value are used as wildcards:
question mark (?) represents any single character
asterisk (*) represents zero or more characters
Standard SQL uses the underscore (_) and percent (%) characters respectively.
string-literal
:
'
{character}'
Character strings can contain any text character. A single quote character (') can be embedded by using two single quote characters.
user-defined-name
:
letter
[ letter
| digit
| _
]...