Re: [patch] Proposal for \crosstabview in psql

On 2/17/16 9:03 AM, Dean Rasheed wrote:
> I'm not totally opposed to specifying a column sort order in psql, and
> perhaps there's a way to support both 'cols' and 'col_order' options
> in psql, since there are different situations where one or the other
> might be more useful.

Yeah. If there was some magic way to reference the underlying data with 
your syntax it probably wouldn't be that bad. AIUI normally we're just 
dumping data into a Portal and there's no option to read back from it, 
but if the query results were first put in a tuplestore then I suspect 
it wouldn't be that hard to query against it and produce another result set.

> What I am opposed to is specifying the row order in psql, because IMO
> that's something that should be done entirely in the SQL query.

+1
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com