On Wed, Mar 13, 2013 at 10:32 AM, Andre Lopes lopes80an...@gmail.comwrote:
Hi all,
I don't know how to ask for this. I need to rotate a Select in
PostgreSql, just like this: http://dpaste.com/1021691/
I can achieve this easily without a procedure?
Hi Andre,
If I understood you want to aggregate comments into a single line... is
it? If yes then you can try this:
SELECT article_id, string_agg(comments, ' ') FROM your_table GROUP BY
article_id;
Best regards,
--
FabrÃzio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter: http://twitter.com/fabriziomello