MD5
Calculate the MD5 hash value for a character string and return the result in hexadecimal format.
MD5(string)
For example:
premdb=# SELECT DISTINCT MD5(ftscore) FROM match ORDER BY 1;
md5
----------------------------------
0299c06aed970473ae41d986b308cd09
0dd954ea204f19a1b391b7828491927b
12426c956d1bc5017082b12a969b0b7c
13cee27a2bd93915479f049378cffdd3
17380ddb842e984302034e1bb66c24e4
1981e4a762b39858dc33f9ea28ed065a
19a1de167122a18af369c749f4e40a48
20fdcfb87379c9a34b5ecbe0dda37ced
2db0874cc1843a7520d8d5fc2f8e3f37
2dd6b4185ffaf931647b896faa2467dd
2f5bb7747efda0546636fb385a3fa593
...
Parent topic:String Functions