return a text agreggate from a subselect - Mailing list pgsql-sql

Hi,

I am trying to convert a subselect that has several matches into one
string comprising all matches concatenated:

The subselect: (SELECT company_name FROM table) 

The output I'd like: 'Company1|Company2|Company3|etc.'

Should I write a function or a new agreggate for this or is there is
simpler way?

Thanks in advance,

--    PANOPE: On dit même qu'au trône une brigue insolente           Veut placer Aricie et le sang de Pallante.
                               (Phèdre, J-B Racine, acte 1, scène 4)