| From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
|---|---|
| To: | "Dean Rasheed" <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
| Cc: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>, "Alvaro Herrera" <alvherre(at)2ndquadrant(dot)com>, "Teodor Sigaev" <teodor(at)sigaev(dot)ru>, "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [patch] Proposal for \crosstabview in psql |
| Date: | 2016-02-09 16:21:34 |
| Message-ID: | 6caba865-30f6-438d-950f-657ea7d9a110@mm |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dean Rasheed wrote:
> Note that I might also want to pass additional sort options, such as
> "ORDER BY name NULLS LAST", which the existing syntax doesn't allow.
> In the new syntax, such sort options could be trivially supported in
> both the server- and client-side sorts:
Note that NULL values in the column that pivots are discarded
by \crosstabview, because NULL as the name of a column does not
make sense.
The doc (in the patch) says:
"The horizontal header, displayed as the first row, contains the set of
all distinct non-null values found in column colH"
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-02-09 16:30:54 | Re: [patch] Proposal for \crosstabview in psql |
| Previous Message | Yury Zhuravlev | 2016-02-09 16:17:07 | Re: GinPageIs* don't actually return a boolean |