On Tue, Sep 8, 2015 at 4:58 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > 2015-09-08 22:55 GMT+02:00 Daniel Verite <dan...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
