Query Advice

All,

Given the following tables:

company
-------
company_id
name

postal_addresses
----------------
postal_address_id
company_id
description
addr
city
stprov
zip

I've been handling joins as such:

select c.company_id,
array(select concat_ws('|', pa.description, pa.addr, pa.city,
pa.stprov, pa.zip)
) addrs
from companies c inner join postal_addresses pa using (company_id)
where company_id = 1731;

Is there a better way to get the company information along with all of the
addresses in a single query? This works, but it requires the additional
step of splitting the addresses by the the delimiter at the application
layer.

Thanks for any advice you have.

--
G.