The ||
operator performs concatenation.
Returns the concatenation of binary1
, binary2
, ...
, binaryN
.
This function provides the same functionality as the
SQL-standard concatenation operator (||
).
Returns the length of binary
in bytes.
Left 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.
Right 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.
Returns 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.
Returns 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.
Returns binary
with the bytes in reverse order.
The Base64 functions implement the encoding specified in RFC 4648.
Decodes binary data from the base64 encoded string
.
Encodes binary
into a base64 string representation.
Decodes binary data from the base64 encoded string
using the URL safe alphabet.
Encodes binary
into a base64 string representation using the URL safe alphabet.
Decodes binary data from the base32 encoded string
.
Encodes binary
into a base32 string representation.
Decodes binary data from the hex encoded string
.
Encodes binary
into a hex string representation.
Decodes the 32-bit two’s complement big-endian binary
.
The input must be exactly 4 bytes.
Encodes integer
into a 32-bit two’s complement big-endian format.
Decodes the 64-bit two’s complement big-endian binary
.
The input must be exactly 8 bytes.
Encodes bigint
into a 64-bit two’s complement big-endian format.
Decodes the 32-bit big-endian binary
in IEEE 754 single-precision floating-point format.
The input must be exactly 4 bytes.
Encodes real
into a 32-bit big-endian binary according to IEEE 754 single-precision floating-point format.
Decodes the 64-bit big-endian binary
in IEEE 754 double-precision floating-point format.
The input must be exactly 8 bytes.
Encodes double
into a 64-bit big-endian binary according to IEEE 754 double-precision floating-point format.
Computes the CRC-32 of binary
. For general purpose hashing, use
xxhash64
, as it is much faster and produces a better quality hash.
Computes the MD5 hash of binary
.
Computes the SHA1 hash of binary
.
Computes the SHA256 hash of binary
.
Computes the SHA512 hash of binary
.
Computes the 32-bit SpookyHashV2 hash of binary
.
Computes the 64-bit SpookyHashV2 hash of binary
.
Computes the xxHash64 hash of binary
.
Computes the 128-bit MurmurHash3
hash of binary
.
Computes HMAC with MD5 of binary
with the given key
.
Computes HMAC with SHA1 of binary
with the given key
.
Computes HMAC with SHA256 of binary
with the given key
.
Computes HMAC with SHA512 of binary
with the given key
.
The ||
operator performs concatenation.
Returns the concatenation of binary1
, binary2
, ...
, binaryN
.
This function provides the same functionality as the
SQL-standard concatenation operator (||
).
Returns the length of binary
in bytes.
Left 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.
Right 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.
Returns 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.
Returns 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.
Returns binary
with the bytes in reverse order.
The Base64 functions implement the encoding specified in RFC 4648.
Decodes binary data from the base64 encoded string
.
Encodes binary
into a base64 string representation.
Decodes binary data from the base64 encoded string
using the URL safe alphabet.
Encodes binary
into a base64 string representation using the URL safe alphabet.
Decodes binary data from the base32 encoded string
.
Encodes binary
into a base32 string representation.
Decodes binary data from the hex encoded string
.
Encodes binary
into a hex string representation.
Decodes the 32-bit two’s complement big-endian binary
.
The input must be exactly 4 bytes.
Encodes integer
into a 32-bit two’s complement big-endian format.
Decodes the 64-bit two’s complement big-endian binary
.
The input must be exactly 8 bytes.
Encodes bigint
into a 64-bit two’s complement big-endian format.
Decodes the 32-bit big-endian binary
in IEEE 754 single-precision floating-point format.
The input must be exactly 4 bytes.
Encodes real
into a 32-bit big-endian binary according to IEEE 754 single-precision floating-point format.
Decodes the 64-bit big-endian binary
in IEEE 754 double-precision floating-point format.
The input must be exactly 8 bytes.
Encodes double
into a 64-bit big-endian binary according to IEEE 754 double-precision floating-point format.
Computes the CRC-32 of binary
. For general purpose hashing, use
xxhash64
, as it is much faster and produces a better quality hash.
Computes the MD5 hash of binary
.
Computes the SHA1 hash of binary
.
Computes the SHA256 hash of binary
.
Computes the SHA512 hash of binary
.
Computes the 32-bit SpookyHashV2 hash of binary
.
Computes the 64-bit SpookyHashV2 hash of binary
.
Computes the xxHash64 hash of binary
.
Computes the 128-bit MurmurHash3
hash of binary
.
Computes HMAC with MD5 of binary
with the given key
.
Computes HMAC with SHA1 of binary
with the given key
.
Computes HMAC with SHA256 of binary
with the given key
.
Computes HMAC with SHA512 of binary
with the given key
.