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

From Merlin Moncure
Subject Re: Select rotate in PostgreSql
Date
Msg-id CAHyXU0xxwjXXT7HGMUOAHyg+V+VqQQHHeBfEih-quL7CWn90uA@mail.gmail.com
Whole thread Raw
In response to Select rotate in PostgreSql  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
On Wed, Mar 13, 2013 at 8: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?

yes: that's not rotation but simple aggregation.  look for string_agg
here: http://www.postgresql.org/docs/9.2/static/functions-aggregate.html

merlin


pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: C++Builder table exist
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: Select rotate in PostgreSql