BUG #13619: regression functions return Null - Mailing list pgsql-bugs

From biswadeep.banerjee@actifio.com
Subject BUG #13619: regression functions return Null
Date
Msg-id 20150914101403.2675.58889@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13619: regression functions return Null  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13619
Logged by:          Biswadeep Banerjee
Email address:      biswadeep.banerjee@actifio.com
PostgreSQL version: 9.4.4
Operating system:   Any
Description:

Hi,
Trending analysis is one of our use case, where I am trying the use the
regression function in postgres 9.4.4.
eg. regr_slope(y,x); regr_intercept(y,x).

I have tried to use the functions to fit in our trending analysis SQL but
returns NULL.
As test also tried with constant values, like,
select regr_slope(4,3), regr_intercept(4,3) from table;

--- returns NULL.

Is this a known issue? or I am using the function differently.

Thanks

pgsql-bugs by date:

Previous
From: Islam Elshobokshy
Date:
Subject: Installation error
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #13619: regression functions return Null