SHA224
Uses the US Secure Hash Algorithm 2 to calculate the SHA224
hash of string. Returns the result as a VARCHAR
string in hexadecimal.
Behavior Type
Syntax
SHA224 ( string )
Parameters
string |
The |
Examples
The following examples calculate the SHA224
hash of the provided strings:
=> SELECT SHA224('abc'); SHA224 ---------------------------------------------------------- 78d8045d684abd2eece923758f3cd781489df3a48e1278982466017f (1 row)
=> SELECT SHA224('Vertica'::bytea); SHA224 ---------------------------------------------------------- 135ac268f64ff3124aeeebc3cc0af0a29fd600a3be8e29ed97e45e25 (1 row)
=> SELECT sha224(''::varbinary) = 'd14a028c2a3a2bc9476102bb288234c415a2b01f828ea62ac5b3e42f' AS "TRUE"; TRUE ------ t (1 row)