Re: [patch] Proposal for \rotate in psql - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [patch] Proposal for \rotate in psql
Date
Msg-id CAFj8pRDQbNmWM7Yz1d5q5qSGgAOMGwqF2SXMsF2cgH90nAtoWA@mail.gmail.com
Whole thread
In response to Re: [patch] Proposal for \rotate in psql  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: [patch] Proposal for \rotate in psql
Re: [patch] Proposal for \rotate in psql
Re: [patch] Proposal for \rotate in psql
List pgsql-hackers
Hi

I am looking on this last patch. I talked about the name of this command with more people, and the name "rotate" is unhappy. The correct name for this visualization technique is "crosstab" (see google "crosstab"). The conflict with our extension is unhappy, but using "rotate" is more worst - (see google "rotate"). The term "rotate" is used less time (related to topic), and usually with zero informed people. More, in attached doc, the word "crosstab" is pretty often used, and then the word "rotate" has not sense.

The important question is sorting output. The vertical header is sorted by first appearance in result. The horizontal header is sorted in ascending or descending order. This is unfriendly for often use case - month names. This can be solved by third parameter - sort function.
 
Regards

Pavel

pgsql-hackers by date:

Previous
From: Nicolas Barbier
Date:
Subject: Re: Bitmap index scans use of filters on available columns
Next
From: Bill Moran
Date:
Subject: Re: RFC/WIP: adding new configuration options to TOAST