summaryrefslogtreecommitdiffstats
path: root/contrib/pgcrypto/sql/md5.sql
blob: 4df910fafbb51e7f60c33fc23e9aa436d3e457d2 (plain)
1
2
3
4
5
6
7
8
9
10
11
--
-- MD5 message digest
--

SELECT encode(digest('', 'md5'), 'hex');
SELECT encode(digest('a', 'md5'), 'hex');
SELECT encode(digest('abc', 'md5'), 'hex');
SELECT encode(digest('message digest', 'md5'), 'hex');
SELECT encode(digest('abcdefghijklmnopqrstuvwxyz', 'md5'), 'hex');
SELECT encode(digest('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789', 'md5'), 'hex');
SELECT encode(digest('12345678901234567890123456789012345678901234567890123456789012345678901234567890', 'md5'), 'hex');