create or replace function hot(ups integer, downs integer, date timestamp with time zone) returns numeric as $$

select round(cast(log(greatest(abs($1 - $2), 1)) + sign($1 - $2) * (date_part('epoch', $3) - 1134028003) / 45000.0 as numeric), 7)

$$ language sql immutable;

create or replace function score(ups integer, downs integer) returns integer as $$

select $1 - $2

$$ language sql immutable;

create or replace function controversy(ups integer, downs integer) returns float as $$

select cast(($1 + $2) as float)/(abs($1 - $2)+1)

$$ language sql immutable;

create or replace function ip_network(ip text) returns text as $$

select substring($1 from E'[\\d]+\.[\\d]+\.[\\d]+')

$$ language sql immutable;

create or replace function base_url(url text) returns text as $$

select substring($1 from E'(?i)(?:.+?://)?(?:www[\\d]*\\.)?([^#]*[^#/])/?')

$$ language sql immutable;

create or replace function domain(url text) returns text as $$

select substring($1 from E'(?i)(?:.+?://)?(?:www[\\d]*\\.)?([^#/]*)/?')

$$ language sql immutable;

create view active as

select pg_stat_activity.procpid, (now() - pg_stat_activity.query_start) as t, pg_stat_activity.current_query from pg_stat_activity where (pg_stat_activity.current_query <> '<IDLE>'::text) order by (now() - pg_stat_activity.query_start);