On 9 February 2016 at 11:06, Pavel Stehule <pavel.steh...@gmail.com> wrote: > + respect SQL clauses ordering, allows pretty complex ORDER BY clause
That, to me is the key point. SQL already allows very powerful sorting, so psql should not just throw away the query's sort order and replace it with something much more basic and limited. The exact syntax can be debated, but I don't think psql should be doing row sorting. I also don't believe that extending the +/- sort syntax to support more advanced options will be particularly easy, and the result is likely to be even less readable. It also requires the user to learn another syntax, when they will already be familiar with SQL's sort syntax. Regards, Dean -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers