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

From Ozer, Pam
Subject Need to return one field for multiple Rows
Date
Msg-id 216FFB77CBFAEE4B8EE4DF0A939FF1D14F87D6@mail-001.corp.automotive.com
Whole thread Raw
Responses Re: Need to return one field for multiple Rows
List pgsql-sql

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

pgsql-sql by date:

Previous
From: Ivan Polak
Date:
Subject: Re: LTREE extension and "order by"
Next
From: "Ozer, Pam"
Date:
Subject: Re: Need to return one field for multiple Rows