SQL statement grammar

This section contains descriptions of the lexical structure.

Netezza Performance Server SQL lexical structure
Grammar overview
Explicit and implicit casting
Implicit casting is the use of internal rules to try to evaluate and process statements that contain mixed data types. This can be helpful when using a function that expects a particular data type, or when issuing a query that compares values that are similar but of different data types. The Netezza Performance Server SQL language is aligned with the SQL Standard for implicit casting of data types.

Parent topic: Database user documentation