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)
Top comments (0)