Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();

version

PostgreSQL 16.0 (Debian 16.0-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

SELECT 1

CREATE TABLE test_regr_intercept_double (
    id int,
    x DOUBLE PRECISION,
    y DOUBLE PRECISION
);

CREATE TABLE

INSERT INTO test_regr_intercept_double (id, x, y) VALUES
    (1, 18.27123456, 13.27123456),
    (2, 14.65890846, 27.65890846),
    (3, 12.25345846, 2.253458468),
    (4, 5.890846835, 6.890846835),
    (5, 10.14345678, 20.14345678);

INSERT 0 5

select regr_intercept(10, x) from test_regr_intercept_double

regr_intercept

10

SELECT 1

select regr_intercept(x, 4) from test_regr_intercept_double

regr_intercept

null

SELECT 1

select regr_intercept(y,x) from test_regr_intercept_double;

select regr_intercept(y,x) from test_regr_intercept_double group by id;

regr_intercept

5.4887751937424225

SELECT 1

regr_intercept

null

null

null

null

null

SELECT 5

TRUNCATE TABLE test_regr_intercept_double;

TRUNCATE TABLE

INSERT INTO test_regr_intercept_double VALUES
        (1, 18, 13),
        (1, NULL, 14),
        (1, 19, NULL),
        (2, 14, 27),
        (2, NULL, NULL);

INSERT INTO test_regr_intercept_double VALUES
        (3, 12, 2),
        (3, 13, 10),
        (3, 14, 20),
        (4, 5, 6),
        (5, 10, 20);

INSERT 0 5

INSERT 0 5

select regr_intercept(10, x) from test_regr_intercept_double;

select regr_intercept(10, x) from test_regr_intercept_double where id >= 3;

select regr_intercept(x, 4) from test_regr_intercept_double;

select regr_intercept(y,x) from test_regr_intercept_double;

select regr_intercept(y,x) from test_regr_intercept_double group by id;

regr_intercept

10

SELECT 1

regr_intercept

10

SELECT 1

regr_intercept

null

SELECT 1

regr_intercept

4.920821114369501

SELECT 1

regr_intercept

-106.33333333333333

null

null

null

null

SELECT 5
regr_intercept
null
null
null
null
null
regr_intercept
-106.33333333333333
null
null
null
null