Functions and operators
Netezza Performance Server SQL provides many functions and operators. Functions are operations that take a value, whereas operators are symbols.
In many cases, you can use functions and operations to do the same task, so the difference is commonly with the syntax.
Netezza Performance Server SQL
supports the following types of functions:
- Numeric
- Performs mathematical operations on numeric data
- Text
- Manipulates strings of text
- Date and time
- Manipulates date and time values and extracts specific components from these values
- System
- Returns information specific to the RDBMS being used
- Fuzzy search and phonetic matching
- Provides approximate string matching that is based on defined techniques or algorithms.
- User-defined
- Performs actions that are defined by the function developer (described in the IBM® Netezza® User-Defined Functions Developer's Guide).