From f3a58f822065150d2b61a2a4699083960725dec8 Mon Sep 17 00:00:00 2001 From: antzucaro Date: Wed, 2 Jan 2013 11:47:42 -0500 Subject: [PATCH] Use greatest instead of least. --- scripts/update_elos.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/scripts/update_elos.sql b/scripts/update_elos.sql index 1665dd2..087f213 100644 --- a/scripts/update_elos.sql +++ b/scripts/update_elos.sql @@ -1,5 +1,5 @@ begin; update player_elos - set elo=least(elo-1, 100.00) + set elo=greatest(elo-1, 100.00) where update_dt < (current_timestamp at time zone 'UTC' - interval '30 days'); end; -- 2.39.2