Re: Need to return one field for multiple Rows - Mailing list pgsql-sql

Never Mind Ifigured it out.  I just need to use agg_array

I have the following query

Select PubArticleId, PubArticlePageXML

from PubarticlePageXml x

Inner Join Pubarticlepage p on x.pubarticlepageid=p.pubarticlepageid

where pubarticleid=188321

Which Returns

PubArticleId(Integer)    PubArticlePageXML(Text)

188321                  fdfaldkjf

188321                  afdaf

188321                  adfafd

188321                  afddfadfa

I want it to return one row

188321 fdfaldkjf afdaf adfafd afddfadfa

Any thoughts On how I can do this?

Thanks