Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE school_probs(school_code bigint, schoolName text, probs numeric[]);

INSERT INTO school_probs VALUES
      ('1', 'CAA', '{0.05,0.08,0.18,0.3,0.11,0.28}')
    , (2, 'CAS', '{0.06,0.1,0.295,0.36,0.12,0.065}')
    , (3, 'CBA', '{0.05,0.11,0.35,0.32,0.12,0.05}')
    , (4, 'CL' , '{0.07,0.09,0.24,0.4,0.06,0.09}')
    , (5, 'EMPTY' , '{}')  -- extended test
    , (6, 'NULL' , NULL);  -- extended test
6 rows affected

SELECT *, ARRAY(SELECT unnest(probs) * 198) AS scaled_probs
FROM   school_probs;


school_code
schoolname
probs
scaled_probs


1
CAA
{0.05,0.08,0.18,0.3,0.11,0.28}
{9.90,15.84,35.64,59.4,21.78,55.44}

2
CAS
{0.06,0.1,0.295,0.36,0.12,0.065}
{11.88,19.8,58.410,71.28,23.76,12.870}

3
CBA
{0.05,0.11,0.35,0.32,0.12,0.05}
{9.90,21.78,69.30,63.36,23.76,9.90}

4
CL
{0.07,0.09,0.24,0.4,0.06,0.09}
{13.86,17.82,47.52,79.2,11.88,17.82}

5
EMPTY
{}
{}

6
NULL
null
{}


SELECT *
FROM   school_probs p
LEFT   JOIN LATERAL (
   SELECT ARRAY(SELECT unnest(p.probs) * 198) AS scaled_probs
   ) p1 ON p.probs IS NOT NULL;


school_code
schoolname
probs
scaled_probs


1
CAA
{0.05,0.08,0.18,0.3,0.11,0.28}
{9.90,15.84,35.64,59.4,21.78,55.44}

2
CAS
{0.06,0.1,0.295,0.36,0.12,0.065}
{11.88,19.8,58.410,71.28,23.76,12.870}

3
CBA
{0.05,0.11,0.35,0.32,0.12,0.05}
{9.90,21.78,69.30,63.36,23.76,9.90}

4
CL
{0.07,0.09,0.24,0.4,0.06,0.09}
{13.86,17.82,47.52,79.2,11.88,17.82}

5
EMPTY
{}
{}

6
NULL
null
null

school_code	schoolname	probs	scaled_probs
1	CAA	{0.05,0.08,0.18,0.3,0.11,0.28}	{9.90,15.84,35.64,59.4,21.78,55.44}
2	CAS	{0.06,0.1,0.295,0.36,0.12,0.065}	{11.88,19.8,58.410,71.28,23.76,12.870}
3	CBA	{0.05,0.11,0.35,0.32,0.12,0.05}	{9.90,21.78,69.30,63.36,23.76,9.90}
4	CL	{0.07,0.09,0.24,0.4,0.06,0.09}	{13.86,17.82,47.52,79.2,11.88,17.82}
5	EMPTY	{}	{}
6	NULL	null	{}