Pl/pgsql array as input to an aggregate function?

SELECT regr_slope(x,y) INTO slope FROM (SELECT unnest(ARRAY1,2,3,4) as x, unnest(ARRAY5,6,7,8) AS y) AS z.

Thanks. This worked for me with one addition. I needed to add in the unnest function: – jeff Oct 24 '10 at 17:15 DROP FUNCTION unnest(anyarray); CREATE OR REPLACE FUNCTION unnest(anyarray) RETURNS SETOF anyelement AS $BODY$ SELECT $1i FROM generate_series(array_lower($1,1),array_upper($1,1)) i; $BODY$ LANGUAGE 'sql' VOLATILE COST 100 ROWS 1000; ALTER FUNCTION unnest(anyarray) OWNER TO postgres; – jeff Oct 24 '10 at 17:16.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.