1--
2-- HMAC-MD5
3--
4SELECT encode(hmac(
5'Hi There',
6decode('0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b', 'hex'),
7'sha1'), 'hex');
8                  encode
9------------------------------------------
10 675b0b3a1b4ddf4e124872da6c2f632bfed957e9
11(1 row)
12
13-- 2
14SELECT encode(hmac(
15'Jefe',
16'what do ya want for nothing?',
17'sha1'), 'hex');
18                  encode
19------------------------------------------
20 156d4c35468a0339f3fa57a067bf47f814eb7a57
21(1 row)
22
23-- 3
24SELECT encode(hmac(
25decode('dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', 'hex'),
26decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
27'sha1'), 'hex');
28                  encode
29------------------------------------------
30 d730594d167e35d5956fd8003d0db3d3f46dc7bb
31(1 row)
32
33-- 4
34SELECT encode(hmac(
35decode('cdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcd', 'hex'),
36decode('0102030405060708090a0b0c0d0e0f10111213141516171819', 'hex'),
37'sha1'), 'hex');
38                  encode
39------------------------------------------
40 4c9007f4026250c6bc8414f9bf50c86c2d7235da
41(1 row)
42
43-- 5
44SELECT encode(hmac(
45'Test With Truncation',
46decode('0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c', 'hex'),
47'sha1'), 'hex');
48                  encode
49------------------------------------------
50 37268b7e21e84da5720c53c4ba03ad1104039fa7
51(1 row)
52
53-- 6
54SELECT encode(hmac(
55'Test Using Larger Than Block-Size Key - Hash Key First',
56decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
57'sha1'), 'hex');
58                  encode
59------------------------------------------
60 aa4ae5e15272d00e95705637ce8a3b55ed402112
61(1 row)
62
63-- 7
64SELECT encode(hmac(
65'Test Using Larger Than Block-Size Key and Larger Than One Block-Size Data',
66decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
67'sha1'), 'hex');
68                  encode
69------------------------------------------
70 e8e99d0f45237d786d6bbaa7965c7808bbff1a91
71(1 row)
72
73