Neoview SQL Reference Manual (R2.3)

Character Data Types...............................................................................................................209
Datetime Data Types................................................................................................................209
Interval Data Types...................................................................................................................210
Numeric Data Types.................................................................................................................210
Character String Data Types..........................................................................................................210
Considerations for Character String Data Types.....................................................................211
Datetime Data Types......................................................................................................................212
Considerations for Datetime Data Types.................................................................................212
Interval Data Types.............................................................................................................................214
Considerations for Interval Data Types.........................................................................................214
Numeric Data Types ...........................................................................................................................215
Expressions..........................................................................................................................................218
Character Value Expressions.........................................................................................................218
Examples of Character Value Expressions...............................................................................218
Datetime Value Expressions..........................................................................................................220
Considerations for Datetime Value Expressions......................................................................221
Examples of Datetime Value Expressions................................................................................221
Interval Value Expressions............................................................................................................223
Considerations for Interval Value Expressions........................................................................224
Examples of Interval Value Expressions..................................................................................225
Numeric Value Expressions...........................................................................................................227
Considerations for Numeric Value Expressions......................................................................227
Examples of Numeric Value Expressions.................................................................................229
Identifiers............................................................................................................................................230
Regular Identifiers.........................................................................................................................230
Delimited Identifiers......................................................................................................................230
Examples of Identifiers..................................................................................................................230
Indexes................................................................................................................................................231
SQL Indexes...................................................................................................................................231
Keys.....................................................................................................................................................232
Clustering Keys..............................................................................................................................232
Index Keys.....................................................................................................................................232
Primary Keys.................................................................................................................................232
Literals.................................................................................................................................................233
Character String Literals................................................................................................................233
Considerations for Character String Literals............................................................................234
Examples of Character String Literals......................................................................................234
Datetime Literals............................................................................................................................235
Examples of Datetime Literals.................................................................................................235
Interval Literals..............................................................................................................................236
Considerations for Interval Literals.........................................................................................237
Examples of Interval Literals....................................................................................................238
Numeric Literals............................................................................................................................238
Examples of Numeric Literals..................................................................................................239
Null......................................................................................................................................................240
Using Null Versus Default Values.................................................................................................240
Defining Columns That Allow or Prohibit Null............................................................................240
Null in DISTINCT, GROUP BY, and ORDER BY Clauses........................................................240
Null and Expression Evaluation Comparison .........................................................................241
SQL Tables.....................................................................................................................................242
Automatically Creating Partitions............................................................................................242
Predicates............................................................................................................................................243
BETWEEN Predicate......................................................................................................................243
Considerations for BETWEEN.................................................................................................244
Examples of BETWEEN............................................................................................................244
Table of Contents 11