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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
