Re: [patch] Proposal for \rotate in psql

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [patch] Proposal for \rotate in psql
Дата
Msg-id CAFj8pRDDjqOz4=BMFLFLrvHp=pj-ziMwx1QxZFPhWJQ+ZmgtRQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [patch] Proposal for \rotate in psql  (Joe Conway <mail@joeconway.com>)
Ответы Re: [patch] Proposal for \rotate in psql
Список pgsql-hackers
Дерево обсуждения


2015-11-04 17:20 GMT+01:00 Joe Conway <mail@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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Request: pg_cancel_backend variant that handles 'idle in transaction' sessions
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Request: pg_cancel_backend variant that handles 'idle in transaction' sessions