Product Documentation

Appearance

All platforms

ERF ​

Run the Gaussian error function on an expression that evaluates to a floating-point number or a compatible data type.

ERF(number)

For example:

premdb=# select erf(0.123456789) from sys.const;
       erf        
-------------------
 0.138601545055623
(1 row)
premdb=# select avg_att, erf(avg_att) from team order by 1 desc limit 3;
 avg_att | erf 
---------+-----
  75.286 |   1
  59.944 |   1
  54.041 |   1
(3 rows)