concat(binary1, ..., binaryN) → varbinaryReturns the concatenation of binary1, binary2, …, binaryN. This function provides the same functionality as the SQL-standard concatenation operator (||).
lpad(binary, size, padbinary) → varbinaryLeft pads binary to size bytes with padbinary. If size is less than the length of binary, the result is truncated to size characters. size must not be negative and padbinary must be non-empty.
rpad(binary, size, padbinary) → varbinaryRight pads binary to size bytes with padbinary. If size is less than the length of binary, the result is truncated to size characters. size must not be negative and padbinary must be non-empty.
substr(binary, start) → varbinaryReturns the rest of binary from the starting position start, measured in bytes. Positions start with 1. A negative starting position is interpreted as being relative to the end of the string.substr(binary, start, length) → varbinaryReturns a substring from binary of length length from the starting position start, measured in bytes. Positions start with 1. A negative starting position is interpreted as being relative to the end of the string.
from_ieee754_32(binary) → realDecodes the 32-bit big-endian binary in IEEE 754 single-precision floating-point format. The input must be exactly 4 bytes.
from_ieee754_64(binary) → doubleDecodes the 64-bit big-endian binary in IEEE 754 double-precision floating-point format. The input must be exactly 8 bytes.
crc32(binary) → bigintComputes the CRC-32 of binary. For general purpose hashing, use xxhash64(), as it is much faster and produces a better quality hash.