REGR_AVGY
Returns the DOUBLE PRECISION
average of the dependent expression in an expression pair. The function eliminates expression pairs where either expression in the pair is NULL
. If no rows remain, the function returns NULL
.
Syntax
REGR_AVGY ( expression1, expression2 )
Parameters
expression1 |
The dependent DOUBLE PRECISION expression
|
expression2 |
The independent DOUBLE PRECISION expression
|
Example
=> SELECT REGR_AVGY (Annual_salary, Employee_age) FROM employee_dimension; REGR_AVGY ------------ 58354.4913 (1 row)