On Wed, Mar 13, 2013 at 10:32 AM, Andre Lopes <lopes80an...@gmail.com>wrote:
> 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