2015-11-04 17:20 GMT+01:00 Joe Conway <m...@joeconway.com>: > On 11/04/2015 04:09 AM, Pavel Stehule wrote: > > 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. > > Apologies if this has already been suggested (as I have not followed the > entire thread), but if you don't want to conflict with the name > crosstab, perhaps "pivot" would be better? >
it is between "rotate" and "crosstab". This name is related to PIVOT operator, what is feature that we want, but it isn't hard problem because we have COPY statement and \copy and we can live with it too. If I understand to text on wiki, the name is used for tool, that can do little bit more things, but it is often used for this technique (so it is much better than "rotate"). I don't understand well, why "crosstab" is too wrong name. This is pretty similar to COPY - and I know, so in first minutes hard to explain this difference between COPY and \copy to beginners, but after day of using there is not any problem. Regards Pavel > > Joe > > -- > Crunchy Data - http://crunchydata.com > PostgreSQL Support for Secure Enterprises > Consulting, Training, & Open Source Development > >
