Postgres Pro
Downloads
Home   >   mailing lists

Re: Select rotate in PostgreSql - Mailing list pgsql-general

From Fabrízio de Royes Mello
Subject Re: Select rotate in PostgreSql
Date
Msg-id CAFcNs+roa4AjOuB71yh+GZaDFxqmPw8NkNSdmQVZ6u7gUDoVmg@mail.gmail.com
Whole thread Raw
In response to Select rotate in PostgreSql  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
Tree view

On Wed, Mar 13, 2013 at 10:32 AM, Andre Lopes <lopes80andre@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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Select rotate in PostgreSql
Next
From: Thor Michael Støre
Date:
Subject: SELECT 1 = ANY (SELECT ARRAY[1,2,3]) -> ERROR: operator does not exist: integer = integer[] ?