Bruce,
Can't a sub select do this (mind you not sure if PostgreSQL supports subselects)?
eg
select company_name, (select com_cat_long from company_category catwhere cat.com_cat_abbr = cpy.com_cat_abbr) from company cpy
Dave