Re: Need to return one field for multiple Rows

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

From: Ozer, Pam
Sent: Thursday, July 21, 2011 4:09 PM
To: pgsql-sql(at)postgresql(dot)org
Subject: Need to return one field for multiple Rows

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

Pam Ozer