Binary Functions
crc32
Computes the CRC-32 of binary. For general purpose hashing, use xxhash64(), as it is much faster and produces a better quality hash.
Supported Signatures
function crc32(varbinary) returns bigint
from_base32
Decodes binary data from the base32 encoded string.
Supported Signatures
function from_base32(varbinary) returns varbinary
function from_base32(varchar) returns varbinary
from_base64
Decodes binary data from the base64 encoded string.
Supported Signatures
function from_base64(varbinary) returns varbinary
function from_base64(varchar) returns varbinary
from_base64url
Decodes binary data from the base64 encoded string using the URL safe alphabet.
Supported Signatures
function from_base64url(varbinary) returns varbinary
function from_base64url(varchar) returns varbinary
from_big_endian_32
Decodes the 32-bit two’s complement big-endian binary. The input must be exactly 4 bytes.
Supported Signatures
function from_big_endian_32(varbinary) returns bigint
from_big_endian_64
Decodes the 64-bit two’s complement big-endian binary. The input must be exactly 8 bytes.
Supported Signatures
function from_big_endian_64(varbinary) returns bigint
from_hex
Decodes binary data from the hex encoded string.
Supported Signatures
function from_hex(varbinary) returns varbinary
function from_hex(varchar) returns varbinary
from_ieee754_32
Decodes the 32-bit big-endian binary in IEEE 754 single-precision floating-point format. The input must be exactly 4 bytes.
Supported Signatures
function from_ieee754_32(varbinary) returns real
from_ieee754_64
Decodes the 64-bit big-endian binary in IEEE 754 double-precision floating-point format. The input must be exactly 8 bytes.
Supported Signatures
function from_ieee754_64(varbinary) returns double
hmac_md5
Computes HMAC with MD5 of binary with the given key.
Supported Signatures
function hmac_md5(varbinary, varbinary) returns varbinary
hmac_sha1
Computes HMAC with SHA1 of binary with the given key.
Supported Signatures
function hmac_sha1(varbinary, varbinary) returns varbinary
hmac_sha256
Computes HMAC with SHA256 of binary with the given key.
Supported Signatures
function hmac_sha256(varbinary, varbinary) returns varbinary
hmac_sha512
Computes HMAC with SHA512 of binary with the given key.
Supported Signatures
function hmac_sha512(varbinary, varbinary) returns varbinary
md5
Computes the MD5 hash of binary.
Supported Signatures
function md5(varbinary) returns varbinary
murmur3
Computes the 128-bit MurmurHash3 hash of binary.
Supported Signatures
function murmur3(varbinary) returns varbinary
sha1
Computes the SHA1 hash of binary.
Supported Signatures
function sha1(varbinary) returns varbinary
sha256
Computes the SHA256 hash of binary.
Examples:
select sha256('Hello World!') as value; -- value '7f83b1657ff1fc53b92dc18148a1d65dfc2d4b1fa3d677284addd200126d9069'
Supported Signatures
function sha256(varbinary) returns varbinary
sha512
Computes the SHA512 hash of binary.
Examples:
select sha512('Hello World!') as value; -- value '861844d6704e8573fec34d967e20bcfef3d424cf48be04e6dc08f2bd58c729743371015ead891cc3cf1c9d34b49264b510751b1ff9e537937bc46b5d6ff4ecc8'
Supported Signatures
function sha512(varbinary) returns varbinary
spooky_hash_v2_32
Computes the 32-bit SpookyHashV2 hash of binary.
Supported Signatures
function spooky_hash_v2_32(varbinary) returns varbinary
spooky_hash_v2_64
Computes the 64-bit SpookyHashV2 hash of binary.
Supported Signatures
function spooky_hash_v2_64(varbinary) returns varbinary
to_base32
Encodes binary into a base32 string representation.
Supported Signatures
function to_base32(varbinary) returns varchar
to_base64
Encodes binary into a base64 string representation.
Supported Signatures
function to_base64(varbinary) returns varchar
to_base64url
Encodes binary into a base64 string representation using the URL safe alphabet.
Supported Signatures
function to_base64url(varbinary) returns varchar
to_big_endian_32
Encodes integer into a 32-bit two’s complement big-endian format.
Supported Signatures
function to_big_endian_32(bigint) returns varbinary
to_big_endian_64
Encodes bigint into a 64-bit two’s complement big-endian format.
Supported Signatures
function to_big_endian_64(bigint) returns varbinary
to_hex
Encodes binary into a hex string representation.
Examples:
SELECT to_hex(cast(1000 as varbinary)) AS value; -- value 'e8030000'
Supported Signatures
function to_hex(varbinary) returns varchar
to_ieee754_32
Encodes real into a 32-bit big-endian binary according to IEEE 754 single-precision floating-point format.
Supported Signatures
function to_ieee754_32(real) returns varbinary
to_ieee754_64
Encodes double into a 64-bit big-endian binary according to IEEE 754 double-precision floating-point format.
Supported Signatures
function to_ieee754_64(double) returns varbinary
xxhash64
Computes the xxHash64 hash of binary.
Supported Signatures
function xxhash64(varbinary) returns varbinary