Need to return one field for multiple Rows

From: "Ozer, Pam" <pozer(at)automotive(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Need to return one field for multiple Rows
Date: 2011-07-21 23:09:28
Message-ID: 216FFB77CBFAEE4B8EE4DF0A939FF1D14F87D6@mail-001.corp.automotive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ozer, Pam 2011-07-21 23:28:46 Re: Need to return one field for multiple Rows
Previous Message Ivan Polak 2011-07-21 17:31:21 Re: LTREE extension and "order by"