AntDB-Oracle Compatibility Developer’s Manual P3–57

REGR_INTERCEPT

Calculate the intercept distance.

Example:

select count(*),regr_intercept(t.num,test.num) from 
(select id-1 as id, num from test) as t,test where t.id=test.id ;
 COUNT(*) | REGR_INTERCEPT(T.NUM,TEST.NUM)  
----------+---------------------------------
       28 |               655.2852157477586
(1 row)

REGR_COUNT

regr_count(y, x) counts the number of records for which neither x nor y is empty.

Example:

create table test(id int, num int);
insert into test values(1, 298),(2, null),(3, null),(null, 328),(null, 108),(6, 667);
select regr_count(id, num) from test;

REGR_COUNT(ID, NUM)  
----------------------
                    2
(1 row)