python-sql

Message98

Author ced
Recipients bell, pokoli
Date 2020-01-03.17:56:08
Message-id <20200103165526.GF6379@kei>
In-reply-to <1578069656.74.0.996058584699.bug65@tryton.org>
On 2020-01-03 17:40, Victor wrote:
> I disagree, these are commonly used aggregate functions.
> For example, the FIRST and LAST functions in Oracle SQL:
> http://sql.standout-dev.com/2018/09/the-first-and-last-functions-in-oracle-sql/
> https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions056.htm

Well Oracle is not really known for following standard.
https://stackoverflow.com/a/46805009/687601 explains clearly why
FIRST/LAST aggregate can not be a standard function:
"because aggregation takes place before sorting".
The link also provides standard alternative (the missing statistics
aggregate function could be added).
History
Date User Action Args
2020-01-03 17:56:08cedsetrecipients: + pokoli, bell
2020-01-03 17:56:08cedlinkbug65 messages
2020-01-03 17:56:08cedcreate