Re: [SQL] Need to return one field for multiple Rows

[Ozer, Pam]

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@postgresql.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