||
operator performs concatenation.
binary1
, binary2
, ...
, binaryN
.
This function provides the same functionality as the
SQL-standard concatenation operator (||
).
binary
in bytes.
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.
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.
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.
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.
binary
with the bytes in reverse order.
string
.
binary
into a base64 string representation.
string
using the URL safe alphabet.
binary
into a base64 string representation using the URL safe alphabet.
string
.
binary
into a base32 string representation.
string
.
binary
into a hex string representation.
binary
.
The input must be exactly 4 bytes.
integer
into a 32-bit two’s complement big-endian format.
binary
.
The input must be exactly 8 bytes.
bigint
into a 64-bit two’s complement big-endian format.
binary
in IEEE 754 single-precision floating-point format.
The input must be exactly 4 bytes.
real
into a 32-bit big-endian binary according to IEEE 754 single-precision floating-point format.
binary
in IEEE 754 double-precision floating-point format.
The input must be exactly 8 bytes.
double
into a 64-bit big-endian binary according to IEEE 754 double-precision floating-point format.
binary
. For general purpose hashing, use
xxhash64
, as it is much faster and produces a better quality hash.
binary
.
binary
.
binary
.
binary
.
binary
.
binary
.
binary
.
binary
.
binary
with the given key
.
binary
with the given key
.
binary
with the given key
.
binary
with the given key
.