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 Raw
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
<div dir="ltr">Hi<br /><div class="gmail_extra"><br /><div class="gmail_quote">I am looking on this last patch. I
talkedabout the name of this command with more people, and the name "rotate" is unhappy. The correct name for this
visualizationtechnique 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
zeroinformed people. More, in attached doc, the word "crosstab" is pretty often used, and then the word "rotate" has
notsense.<br /><br /></div><div class="gmail_quote">The important question is sorting output. The vertical header is
sortedby first appearance in result. The horizontal header is sorted in ascending or descending order. This is
unfriendlyfor often use case - month names. This can be solved by third parameter - sort function. <br /> <br
/></div><divclass="gmail_quote">Regards<br /><br /></div><div class="gmail_quote">Pavel<br /></div></div></div> 

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