HASHTYPE_SHA[1]

Purpose

This function computes a hash value by using the SHA1 algorithm (160 Bit).

Syntax

hashtype_sha1::=

HASHTYPE_SHA1

Usage notes

  • Return values have data type HASHTYPE(20 byte).
  • The data types of the input parameters are significant. That is why HASHTYPE_SHA1(123) is different to HASHTYPE_SHA1('123').
  • Multiple input expressions are concatenated (in their internal byte representation) before the hash value is computed.

    • HASHTYPE_SHA1(c1,c2) is not similar to HASHTYPE_SHA1(c1||c2).

  • The function returns NULL if all input expressions are NULL.
  • HASHTYPE_SHA() is an alias for HASHTYPE_SHA1().

Example

Copy 
SELECT HASHTYPE_SHA1('abc');