RoundSparrow @ BTM to Lemmy Project Priorities Observations • 1 year ago2023-08-18message-square13arrow-up11arrow-down10
arrow-up11arrow-down1message-square2023-08-18RoundSparrow @ BTM to Lemmy Project Priorities Observations • 1 year agomessage-square13
minus-squareRoundSparrow @ BTOPMlinkfedilink1•1 year agoCREATE FUNCTION public.hot_rank(score numeric, published timestamp without time zone) RETURNS integer LANGUAGE plpgsql IMMUTABLE PARALLEL SAFE AS $$ DECLARE hours_diff numeric := EXTRACT(EPOCH FROM (timezone('utc', now()) - published)) / 3600; BEGIN IF (hours_diff > 0) THEN RETURN floor(10000 * log(greatest (1, score + 3)) / power((hours_diff + 2), 1.8))::integer; ELSE RETURN 0; END IF; END; $$;