Thread: Need to return one field for multiple Rows

Need to return one field for multiple Rows

From

"Ozer, Pam"

Date:

21 July 2011, 23:26:47

<div class="WordSection1"><p class="MsoNormal">I have the following query<p class="MsoNormal"> <p
class="MsoNormal">SelectPubArticleId, PubArticlePageXML<p class="MsoNormal">from PubarticlePageXml x<p
class="MsoNormal">InnerJoin Pubarticlepage p on x.pubarticlepageid=p.pubarticlepageid <p class="MsoNormal">where
pubarticleid=188321<pclass="MsoNormal"> <p class="MsoNormal">Which Returns<p class="MsoNormal">PubArticleId(Integer)   
PubArticlePageXML(Text)<pclass="MsoNormal">188321                  fdfaldkjf<p
class="MsoNormal">188321                 afdaf<p class="MsoNormal">188321                  adfafd<p
class="MsoNormal">188321                 afddfadfa<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal">Iwant it to return one row<p class="MsoNormal"> <p class="MsoNormal">188321 fdfaldkjf afdaf adfafd
afddfadfa<pclass="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal">Any thoughts On how I can do this?<p
class="MsoNormal"> <pclass="MsoNormal">Thanks<p class="MsoNormal"> <div id="content"><p class="MsoNormal"><b><span
style="font-size:11.5pt;font-family:"Arial","sans-serif";color:black">PamOzer</span></b></div></div>

Re: Need to return one field for multiple Rows

From

"Ozer, Pam"

Date:

21 July 2011, 23:28:53

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