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 CAFj8pRCWqWT-dVbNRR4JAyWu=BheB3ZzXSfE6vYUNiaj4wfEHQ@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  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: [patch] Proposal for \rotate in psql  ("Daniel Verite" <daniel@manitou-mail.org>)
Re: [patch] Proposal for \rotate in psql  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-hackers
<div dir="ltr"><br /><div class="gmail_extra">Hi<br /></div><div class="gmail_extra"><br /><div
class="gmail_quote">2015-09-1611:35 GMT+02:00 Daniel Verite <span dir="ltr"><<a
href="mailto:daniel@manitou-mail.org"target="_blank">daniel@manitou-mail.org</a>></span>:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">  Hi,<br /><br /> This is the
2nditeration of this patch, for comments and review.<br /><br /><br /><div class="HOEnZb"><div class="h5"><br
/></div></div></blockquote></div><br/></div><div class="gmail_extra">my comments:<br /><br /></div><div
class="gmail_extra">1.I don't understand why you are use two methods for sorting columns (qsort, and query with ORDER
BY)<br/><br /></div><div class="gmail_extra">2. Data column are not well aligned - numbers are aligned as text<br /><br
/></div><divclass="gmail_extra">3. When data are multiattribute - then merging together with space separator is not
practical<br/><br /></div><div class="gmail_extra">  * important information is lost<br /></div><div
class="gmail_extra"> * same transformation can be done as expression, so this feature is useless<br /><br /></div><div
class="gmail_extra">Ispossible to use one cell per attribute (don't do merge)?<br /><br /></div><div
class="gmail_extra">DATAQUERY: SELECT dim1, dim2, sum(x), avg(x) FROM .. GROUP BY dim1, dim2<br /><br /></div><div
class="gmail_extra">andresult header of rotate can be<br /><br /></div><div class="gmail_extra">DIM1   | dim2_val1/sum
|dim2_val1/avg | dim2_val2/sum | dim2_val2/avg | ...<br /><br /></div><div class="gmail_extra"><br /></div><div
class="gmail_extra"><br/></div></div> 

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: numbering plan nodes
Next
From: Robert Haas
Date:
Subject: Re: On-demand running query plans using auto_explain and signals