md5_number()

Returns the MD5 hash of the value as an INT128

Arguments & returns

2 overloads

Scalar

Overload link	`value`	Returns
#01	`BLOB`	`UHUGEINT`
#02	`VARCHAR`	`UHUGEINT`

SELECT md5_number('\xAA\xBB'::BLOB);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT md5_number('abc');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT
  md5_number('123');