On Tue, Sep 8, 2015 at 4:58 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> 2015-09-08 22:55 GMT+02:00 Daniel Verite <daniel@manitou-mail.org>:
>>
>> Pavel Stehule wrote:
>>
>> > rotate ~ sounds like transpose matrix, what is not true in this case.
>
> for me the relation rotation is exactly what \x does
\x doesn't exactly rotate it either. \x puts the column headers down
the side instead of across the top, but it doesn't put the rows across
the top instead of down the side. Rather, each row is listed in a
separate chunk. This feature is doing something else again. I've
actually never seen this particular transformation anywhere except for
Microsoft Excel's pivot tables, which I still find confusing.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company