hkp=# select distinct fp from (select reverse(pubkey_uuid) as fp from openpgp_sig where signer like reverse(lower('605EC01F47D46D61')) || '%') as fps;
                    fp                    
------------------------------------------
 da0ee89fc061155671a5518339aeff3d971aec96
 44eef84f86f8733c9bb02377605ec01f47d46d61
 0c0048e89d9888e6af7d865ba79a45668240ab6c
 78adb3115f7d8bc38cd75803c4982c0b2f49017d
 3e3cf5acdfe1eb9e6e6af6598932fd2ac45f1e80
 4bddcc71dbdb58a578d033821ef62e9684ea0c8f
 3e1a0f261738227462c9c1ff55393aac
 2cfdfb436e2f2ddd91d993272fd21907f40a0111
 2d6d67d1160004e04af7ba7e26a5418992281585
 d48c96453af57a1d597e380d24fa513627ed2046
 dfc6fcbc80ae94094f7b97d394d1c97bf2404877
 52514facd68488455604e44fd65c392fd91b4729
 29f20c6180fbdba115b4e45c2a572e4c3495178b
(13 rows)

hkp=# select distinct fp from (select reverse(signer) as fp from openpgp_sig where pubkey_uuid like reverse(lower('605EC01F47D46D61')) || '%') as fps;
        fp        
------------------
 605ec01f47d46d61
 29129e38508d98ed
 2fd21907f40a0111
 fd82fc03bed09971
(4 rows)