Scalar Functions and Operators

Hyper provides a large number of functions and operators for the built-in data types.

If you are concerned about portability then note that most of the functions and operators described in this chapter, with the exception of the most trivial arithmetic and comparison operators and some explicitly marked functions, are not specified by the SQL standard. Some of this extended functionality is present in other SQL database management systems, in particular PostgreSQL, and in many cases this functionality is compatible and consistent between the various database systems.

📄️ Type Conversions

Converting from one data type to another can be done using CAST or TRY_CAST.

📄️ Comparison Operators

Comparison operators compare a value against another value.

📄️ Subquery Comparisons

This section describes the SQL-compliant subquery expressions available

📄️ Logical Operators

The usual logical operators are available for boolean values:

📄️ Conditional Expressions

The conditional expressions select one of multiple result values.

📄️ Mathematical Functions and Operators

Mathematical operators are provided for many Hyper types. For types

📄️ String Functions and Operators

This section describes functions and operators for examining and

📄️ String Pattern Matching

There are two separate approaches to pattern matching provided by Hyper:

📄️ Data Type Formatting Functions

The Hyper formatting functions provide a powerful set of tools for

📄️ Array Functions

This section describes functions and operators to inspect and transform array values. In the following, array(T) denotes an array type with element type T.

📄️ Date/Time Functions and Operators

Functions show the available functions

📄️ Geographic Functions

Geographical functions operate on geographic input, like points, lines