You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
15 lines
393 B
15 lines
393 B
-- Add up migration script here
|
|
CREATE OR REPLACE FUNCTION iihf_points(game_id INT, team_id INT)
|
|
RETURNS INTEGER AS $$
|
|
BEGIN
|
|
RETURN (
|
|
SELECT
|
|
(iihf_stats.reg_win * 3) +
|
|
(iihf_stats.reg_loss * 0) +
|
|
(iihf_stats.ot_win * 2) +
|
|
(iihf_stats.ot_loss * 1) +
|
|
(iihf_stats.tie * 2) AS points
|
|
FROM iihf_stats(game_id, team_id) iihf_stats);
|
|
END;
|
|
$$ LANGUAGE plpgsql;
|