Extreme DPS Function Reference

Extreme DPS supports most of the standard functions defined in SQL:1999 and some PostgreSQL extensions. This reference provides syntax, description, examples, and other details for using each supported function.

📄️ Logical Operators

Logical operators evaluate to a Boolean value or null (unknown) on one or two expressions.

📄️ Comparison Functions and Operators

Comparison functions and operators produce a Boolean value or null (unknown) on two expressions.

📄️ Mathematical Functions and Operators

Mathematical functions and operators evaluate to a numeric value on one or two input expressions.

📄️ String Functions and Operators

String functions and operators process string inputs and return string or numeric values. The string types supported by Extreme DPS are varchar and text. For more information about the string types, see Character Types.

📄️ Pattern Matching

Extreme DPS allows you to use the LIKE operator and regular expressions to implement pattern matching.

📄️ Conditional Expressions

Several SQL-compliant conditional expressions are available in Extreme DPS, namely CASE WHEN, COALESCE, NULLIF, and GREATEST and LEAST.

📄️ Data Type Formatting Functions

Data type formatting functions are used to convert various data types into formatted strings, and vice versa. The data type formatting functions in Relyt all follow a common calling convention: the first argument is the value to be formatted, and the second argument is a template that defines the format for the output or input.

📄️ Date/Time Functions and Operators

Extreme DPS allows you to use several functions to process date/time values.

📄️ Aggregate Functions

Aggregate functions perform a calculation on a set of values and return a single value. Extreme DPS provides many aggregate functions to help you analyze data.

📄️ Row and Array Comparisons

Extreme DPS allows you to use IN or NOT IN to make multiple comparisons between groups of values.

📄️ Conversion Functions

When processing queries, Extreme DPS implicitly converts numeric and character values to the correct types if possible. However, Extreme DPS does not support direct conversions between numeric and character values. To perform conversions from numeric types to character types or from character types to numeric types, conversion functions must be used.