Re: documentation extension request - order with function over aggregated functions

2020-02-04 Thread Laurenz Albe
On Tue, 2020-02-04 at 08:59 +, PG Doc comments form wrote: > SELECT a + b AS sum, c FROM table1 ORDER BY sum + c; -- wrong > > It took me a while to figure out how to do it properly so I propose to add > the following (or similar) info: > > --- > If you need to sort by this kind of e

documentation extension request - order with function over aggregated functions

2020-02-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/queries-order.html Description: In https://www.postgresql.org/docs/9.5/queries-order.html it is said that the following is intentionally not allowed: ``` SELECT a + b AS sum, c FROM tabl