Add an indexed array column (of type text[]) to contain approved variants?

Or add an indexed array column (of type text[]) of md5's to contain the md5's of approved variants? ( postgres md5 documentation ).

(Admittedly, I don't quite get the problem: the code you posted just works for me, with the mangled company name)