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

πŸ”— Official Documentation

from_base32

Decodes binary data from the base32 encoded string.

Supported Signatures

function from_base32(varbinary) returns varbinary
function from_base32(varchar) returns varbinary

πŸ”— Official Documentation

from_base64

Decodes binary data from the base64 encoded string.

Supported Signatures

function from_base64(varbinary) returns varbinary
function from_base64(varchar) returns varbinary

πŸ”— Official Documentation

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

πŸ”— Official Documentation

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

πŸ”— Official Documentation

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

πŸ”— Official Documentation

from_hex

Decodes binary data from the hex encoded string.

Supported Signatures

function from_hex(varbinary) returns varbinary
function from_hex(varchar) returns varbinary

πŸ”— Official Documentation

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

πŸ”— Official Documentation

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

πŸ”— Official Documentation

hmac_md5

Computes HMAC with MD5 of binary with the given key.

Supported Signatures

function hmac_md5(varbinary, varbinary) returns varbinary

πŸ”— Official Documentation

hmac_sha1

Computes HMAC with SHA1 of binary with the given key.

Supported Signatures

function hmac_sha1(varbinary, varbinary) returns varbinary

πŸ”— Official Documentation

hmac_sha256

Computes HMAC with SHA256 of binary with the given key.

Supported Signatures

function hmac_sha256(varbinary, varbinary) returns varbinary

πŸ”— Official Documentation

hmac_sha512

Computes HMAC with SHA512 of binary with the given key.

Supported Signatures

function hmac_sha512(varbinary, varbinary) returns varbinary

πŸ”— Official Documentation

md5

Computes the MD5 hash of binary.

Supported Signatures

function md5(varbinary) returns varbinary

πŸ”— Official Documentation

murmur3

Computes the 128-bit MurmurHash3 hash of binary.

Supported Signatures

function murmur3(varbinary) returns varbinary

πŸ”— Official Documentation

sha1

Computes the SHA1 hash of binary.

Supported Signatures

function sha1(varbinary) returns varbinary

πŸ”— Official Documentation

sha256

Computes the SHA256 hash of binary.

Examples:

examples.sql
select sha256('Hello World!') as value; -- value '7f83b1657ff1fc53b92dc18148a1d65dfc2d4b1fa3d677284addd200126d9069'

Supported Signatures

function sha256(varbinary) returns varbinary

πŸ”— Official Documentation

sha512

Computes the SHA512 hash of binary.

Examples:

examples.sql
select sha512('Hello World!') as value; -- value '861844d6704e8573fec34d967e20bcfef3d424cf48be04e6dc08f2bd58c729743371015ead891cc3cf1c9d34b49264b510751b1ff9e537937bc46b5d6ff4ecc8'

Supported Signatures

function sha512(varbinary) returns varbinary

πŸ”— Official Documentation

spooky_hash_v2_32

Computes the 32-bit SpookyHashV2 hash of binary.

Supported Signatures

function spooky_hash_v2_32(varbinary) returns varbinary

πŸ”— Official Documentation

spooky_hash_v2_64

Computes the 64-bit SpookyHashV2 hash of binary.

Supported Signatures

function spooky_hash_v2_64(varbinary) returns varbinary

πŸ”— Official Documentation

to_base32

Encodes binary into a base32 string representation.

Supported Signatures

function to_base32(varbinary) returns varchar

πŸ”— Official Documentation

to_base64

Encodes binary into a base64 string representation.

Supported Signatures

function to_base64(varbinary) returns varchar

πŸ”— Official Documentation

to_base64url

Encodes binary into a base64 string representation using the URL safe alphabet.

Supported Signatures

function to_base64url(varbinary) returns varchar

πŸ”— Official Documentation

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

πŸ”— Official Documentation

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

πŸ”— Official Documentation

to_hex

Encodes binary into a hex string representation.

Examples:

examples.sql
SELECT to_hex(cast(1000 as varbinary)) AS value; -- value 'e8030000'

Supported Signatures

function to_hex(varbinary) returns varchar

πŸ”— Official Documentation

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

πŸ”— Official Documentation

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

πŸ”— Official Documentation

xxhash64

Computes the xxHash64 hash of binary.

Supported Signatures

function xxhash64(varbinary) returns varbinary

πŸ”— Official Documentation

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

πŸ”— Official Documentation

from_base32

Decodes binary data from the base32 encoded string.

Supported Signatures

function from_base32(varbinary) returns varbinary
function from_base32(varchar) returns varbinary

πŸ”— Official Documentation

from_base64

Decodes binary data from the base64 encoded string.

Supported Signatures

function from_base64(varbinary) returns varbinary
function from_base64(varchar) returns varbinary

πŸ”— Official Documentation

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

πŸ”— Official Documentation

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

πŸ”— Official Documentation

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

πŸ”— Official Documentation

from_hex

Decodes binary data from the hex encoded string.

Supported Signatures

function from_hex(varbinary) returns varbinary
function from_hex(varchar) returns varbinary

πŸ”— Official Documentation

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

πŸ”— Official Documentation

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

πŸ”— Official Documentation

hmac_md5

Computes HMAC with MD5 of binary with the given key.

Supported Signatures

function hmac_md5(varbinary, varbinary) returns varbinary

πŸ”— Official Documentation

hmac_sha1

Computes HMAC with SHA1 of binary with the given key.

Supported Signatures

function hmac_sha1(varbinary, varbinary) returns varbinary

πŸ”— Official Documentation

hmac_sha256

Computes HMAC with SHA256 of binary with the given key.

Supported Signatures

function hmac_sha256(varbinary, varbinary) returns varbinary

πŸ”— Official Documentation

hmac_sha512

Computes HMAC with SHA512 of binary with the given key.

Supported Signatures

function hmac_sha512(varbinary, varbinary) returns varbinary

πŸ”— Official Documentation

md5

Computes the MD5 hash of binary.

Supported Signatures

function md5(varbinary) returns varbinary

πŸ”— Official Documentation

murmur3

Computes the 128-bit MurmurHash3 hash of binary.

Supported Signatures

function murmur3(varbinary) returns varbinary

πŸ”— Official Documentation

sha1

Computes the SHA1 hash of binary.

Supported Signatures

function sha1(varbinary) returns varbinary

πŸ”— Official Documentation

sha256

Computes the SHA256 hash of binary.

Examples:

examples.sql
select sha256('Hello World!') as value; -- value '7f83b1657ff1fc53b92dc18148a1d65dfc2d4b1fa3d677284addd200126d9069'

Supported Signatures

function sha256(varbinary) returns varbinary

πŸ”— Official Documentation

sha512

Computes the SHA512 hash of binary.

Examples:

examples.sql
select sha512('Hello World!') as value; -- value '861844d6704e8573fec34d967e20bcfef3d424cf48be04e6dc08f2bd58c729743371015ead891cc3cf1c9d34b49264b510751b1ff9e537937bc46b5d6ff4ecc8'

Supported Signatures

function sha512(varbinary) returns varbinary

πŸ”— Official Documentation

spooky_hash_v2_32

Computes the 32-bit SpookyHashV2 hash of binary.

Supported Signatures

function spooky_hash_v2_32(varbinary) returns varbinary

πŸ”— Official Documentation

spooky_hash_v2_64

Computes the 64-bit SpookyHashV2 hash of binary.

Supported Signatures

function spooky_hash_v2_64(varbinary) returns varbinary

πŸ”— Official Documentation

to_base32

Encodes binary into a base32 string representation.

Supported Signatures

function to_base32(varbinary) returns varchar

πŸ”— Official Documentation

to_base64

Encodes binary into a base64 string representation.

Supported Signatures

function to_base64(varbinary) returns varchar

πŸ”— Official Documentation

to_base64url

Encodes binary into a base64 string representation using the URL safe alphabet.

Supported Signatures

function to_base64url(varbinary) returns varchar

πŸ”— Official Documentation

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

πŸ”— Official Documentation

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

πŸ”— Official Documentation

to_hex

Encodes binary into a hex string representation.

Examples:

examples.sql
SELECT to_hex(cast(1000 as varbinary)) AS value; -- value 'e8030000'

Supported Signatures

function to_hex(varbinary) returns varchar

πŸ”— Official Documentation

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

πŸ”— Official Documentation

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

πŸ”— Official Documentation

xxhash64

Computes the xxHash64 hash of binary.

Supported Signatures

function xxhash64(varbinary) returns varbinary

πŸ”— Official Documentation