Home > mailing lists

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

From	Pavel Stehule
Subject	Re: [patch] Proposal for \rotate in psql
Date	September 17, 2015 18:47:58
Msg-id	CAFj8pRCWqWT-dVbNRR4JAyWu=BheB3ZzXSfE6vYUNiaj4wfEHQ@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

2015-09-16 11:35 GMT+02:00 Daniel Verite <daniel@manitou-mail.org>:

Hi,

This is the 2nd iteration of this patch, for comments and review.

my comments:

1. I don't understand why you are use two methods for sorting columns (qsort, and query with ORDER BY)

2. Data column are not well aligned - numbers are aligned as text

3. When data are multiattribute - then merging together with space separator is not practical

* important information is lost

* same transformation can be done as expression, so this feature is useless

Is possible to use one cell per attribute (don't do merge)?

DATA QUERY: SELECT dim1, dim2, sum(x), avg(x) FROM .. GROUP BY dim1, dim2

and result header of rotate can be

From: Robert Haas
Date: 17 September 2015, 18:44:06
Subject: Re: numbering plan nodes

From: Robert Haas
Date: 17 September 2015, 20:13:18
Subject: Re: On-demand running query plans using auto_explain and signals