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

From Daniel Verite
Subject Re: [patch] Proposal for \crosstabview in psql
Date
Msg-id 6caba865-30f6-438d-950f-657ea7d9a110@mm
Whole thread Raw
In response to Re: [patch] Proposal for \crosstabview in psql  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: [patch] Proposal for \crosstabview in psql
List 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



pgsql-hackers by date:

Previous
From: Yury Zhuravlev
Date:
Subject: Re: GinPageIs* don't actually return a boolean
Next
From: Tom Lane
Date:
Subject: Re: [patch] Proposal for \crosstabview in psql