Operations Overview

RayforceDB provides a comprehensive set of operations for data manipulation and analysis.

Scalar Values

A scalar is a single atomic value, as opposed to a vector or collection. Scalars include:

• Integers - I8, I16, I32, I64 (signed) and U8, U16, U32, U64 (unsigned)
• Floats - F32, F64 for floating-point numbers
• Temporal - Dates, times, timestamps, and timespans
• Symbols - Interned strings for efficient comparison
• Characters - Single character values
• Booleans - true and false
• GUIDs - Globally unique identifiers

Operation Categories

Math Operations

Arithmetic, aggregation, and mathematical functions for numeric data.

Order Operations

Sorting, ranking, and ordering functions.

Iterable Operations

Functions for working with collections and sequences.

Logic Operations

Boolean and comparison operations.

Compose Operations

Function composition and higher-order operations.