WL#3720: Enhanced Numeric Functions
Affects: Server-7.1
—
Status: Un-Assigned
Fully support SQL:2003 non-core standard feature T621 "Enhanced numeric functions".
These T621 functions are already in MySQL:
CEILING, COVAR_POP, COVAR_POP, EXP LN, SQRT,
STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP.
These T621 functions are not in MySQL, are in
Oracle, and are in PostgreSQL 8.2:
CORR ("correlation coefficient"), REGR_SLOPE
REGR_INTERCEPT REGR_COUNT REGR_R2 REGR_AVGX
REGR_SXX REGR_SYY (all REGR functions are
linear regression functions). The ANSI/ISO
term is "binary set functions", the PostgreSQL
term is "statistical functions".
This T621 function is not in MySQL, is in Oracle,
and is not in PostgreSQL 8.2: WIDTH_BUCKET.
It's not part of this task because it's already
part of another task: WL#2266 OLAP.
References
----------
Oracle, "REGR_ (Linear Regression) Functions"
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/functions132.htm#i85922
"SQL In a Nutshell", "Chapter 4: SQL Functions", Kevin Kline
http://www.oreilly.com/catalog/sqlnut2/chapter/ch04.pdf
In the "ANSI SQL Aggregate Functions" sample chapter,
there is a description of most of these functions and the
DBMSs that support them, as of 2004.
"ora_funcs: A set of UDFs that implement some Oracle specific SQL functions not
available in MySQL"
http://forge.mysql.com/projects/view.php?id=100
Copyright (c) 2000, 2025, Oracle Corporation and/or its affiliates. All rights reserved.