subject:"\[SQL\] Need to return one field for multiple Rows"

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

2011-07-21 Thread 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

[SQL] Need to return one field for multiple Rows

2011-07-21 Thread Ozer, Pam

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 1