diff options
author | Dessalines <tyhou13@gmx.com> | 2019-04-21 10:15:40 -0700 |
---|---|---|
committer | Dessalines <tyhou13@gmx.com> | 2019-04-21 10:15:40 -0700 |
commit | 93957c781e3d0e1a97f6cdca2a3505da9374892e (patch) | |
tree | 18e9401137bd086dfd29f7a8dc09faa18053a635 /server/migrations | |
parent | 811607f81aecb8444730ec47365297381813ebd5 (diff) |
Fixing ranking algorithm.
Diffstat (limited to 'server/migrations')
-rw-r--r-- | server/migrations/2019-03-30-212058_create_post_view/up.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/server/migrations/2019-03-30-212058_create_post_view/up.sql b/server/migrations/2019-03-30-212058_create_post_view/up.sql index 3a509e29..17dc8604 100644 --- a/server/migrations/2019-03-30-212058_create_post_view/up.sql +++ b/server/migrations/2019-03-30-212058_create_post_view/up.sql @@ -5,7 +5,7 @@ create or replace function hot_rank( returns integer as $$ begin -- hours_diff:=EXTRACT(EPOCH FROM (timezone('utc',now()) - published))/3600 - return floor(10000*sign(3+score)*log(abs(3+score)) / power(((EXTRACT(EPOCH FROM (timezone('utc',now()) - published))/3600) + 2), 1.8))::integer; + return floor(10000*log(greatest(1,score+3)) / power(((EXTRACT(EPOCH FROM (timezone('utc',now()) - published))/3600) + 2), 1.8))::integer; end; $$ LANGUAGE plpgsql; |