HASH_TIGER

Purpose

This function computes a hash value by using the tiger algorithm (192 Bit).

Syntax

hash_tiger::=

Hash_tiger

Usage Notes

  • Return values have data type CHAR(48) and contain hex characters.
  • The data types of the input parameters are significant. That is why HASH_TIGER(123) is different to HASH_TIGER('123').
  • Multiple input expressions are concatenated (in their internal byte representation) before the hash value is computed.

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

  • The function returns NULL if all input expressions are NULL.

Example

Copy 
SELECT HASH_TIGER('abc');