hkp=# SELECT reverse(pubkey_uuid),keywords FROM openpgp_uid WHERE pubkey_uuid IN ( select distinct fp from (select pubkey_uuid as fp from openpgp_sig where signer like reverse(lower('1c8d2e6bdc33b0ee')) || '%' and pubkey_uuid NOT LIKE reverse(lower('1c8d2e6bdc33b0ee')) || '%') as fps );
                 reverse                  |                              keyword
s
------------------------------------------+-------------------------------------
-------------------------------
 53687a1a7bacaa700721f9ab36ba656112ee3000 | Alex Legler <alex.legler@denkbares.c
om>
 53687a1a7bacaa700721f9ab36ba656112ee3000 | Alex Legler <alexander.legler@stud-m
ail.uni-wuerzburg.de>
 53687a1a7bacaa700721f9ab36ba656112ee3000 | Alex Legler <alex@a3li.li>
 53687a1a7bacaa700721f9ab36ba656112ee3000 | Alex Legler <mail@alex-legler.de>
 53687a1a7bacaa700721f9ab36ba656112ee3000 | Alex Legler <legler@informatik.uni-w
uerzburg.de>
 53687a1a7bacaa700721f9ab36ba656112ee3000 | Alex Legler <a3li@gentoo.org>
 0f0131a6bd648c4ca1876253ba2733a7e28c7bb4 | Craig <craig@haquarter.de>
 0f0131a6bd648c4ca1876253ba2733a7e28c7bb4 | Stefan Behte <craig@gentoo.org>
 94cbafdd30345109561835aa0b7f8b60e3edfae3 | Kristian Fiskerstrand <kristian.fisk
erstrand@sumptuouscapital.com>
 94cbafdd30345109561835aa0b7f8b60e3edfae3 | Kristian Fiskerstrand <k_f@gentoo.or
g>
 94cbafdd30345109561835aa0b7f8b60e3edfae3 | Kristian Fiskerstrand <kf@gnupg.net>
 94cbafdd30345109561835aa0b7f8b60e3edfae3 | Kristian Fiskerstrand <kf@sumptuousc
apital.com>
 eeb1c3417c84b2746c59f2435eab0c62b427abc8 | Christian Ruppert <idl0r@gentoo.org>
 eeb1c3417c84b2746c59f2435eab0c62b427abc8 | Christian Ruppert <spooky85@gmail.co
m>
 eeb1c3417c84b2746c59f2435eab0c62b427abc8 | Christian Ruppert <idl0r@qasl.de>
(15 rows)


hkp=#  select distinct fp from (select reverse(signer) as fp from openpgp_sig where pubkey_uuid like reverse(lower('1c8d2e6bdc33b0ee')) || '%' AND signer NOT LIKE reverse(lower('1c8d2e6bdc33b0ee')) || '%') as fps;
        fp        
------------------
 ba2733a7e28c7bb4
 5eab0c62b427abc8
 36ba656112ee3000
 0ff201209ce3ca91
 60c0742d1f357d42
(5 rows)