David Kerr <dmk@xxxxxxxxxxxxxx> writes: > But, i don't see any coded loop or way for me to insert a signal check. (I'm not much of a > programmer) the function was just: > CREATE OR REPLACE FUNCTION array_median(anyarray) > RETURNS anyelement AS > $$ > SELECT CASE > WHEN array_upper($1,1) = 0 THEN null > WHEN mod(array_upper($1,1),2) = 1 THEN > asorted[ceiling(array_upper(asorted,1)/2.0)] > ELSE > ((asorted[ceiling(array_upper(asorted,1)/2.0)] + asorted[ceiling(array_upper(asorted,1)/2.0)+1])/2.0) END > FROM (SELECT ARRAY(SELECT ($1)[n] FROM > generate_series(1, array_upper($1, 1)) AS n > WHERE ($1)[n] IS NOT NULL > ORDER BY ($1)[n] > ) As asorted) As foo ; > $$ > LANGUAGE 'sql' IMMUTABLE; Huh. How big an array were you trying to invoke it on? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
