REGR_AVGX

Returns the DOUBLE PRECISION average of the independent expression in an expression pair. REGR_AVGX eliminates expression pairs where either expression in the pair is NULL. If no rows remain, REGR_AVGX returns NULL.

Syntax

SELECT REGR_AVGX ( expression1, expression2 )

Parameters

expression1 The dependent DOUBLE PRECISION expression
expression2 The independent DOUBLE PRECISION expression

Example

=> SELECT REGR_AVGX (Annual_salary, Employee_age) 
      FROM employee_dimension;
 REGR_AVGX
-----------
    39.321
(1 row)