Help with a trigger

Not a trigger expert... I would like to sum the

num

num

num

num of confirmed

players

players

players

players in the

games

games

games

games table each time a player record is created, updated or deleted. Here’s my non-working code:

drop function if exists games_players cascade;

create or replace function games_players()
returns trigger as $$ begin
update games set players_conf = (select sum(players.num) AS num from players where players.game_id = NEW.game_id group by players.game_id) where games.id = NEW.game_id;
return NEW;
end;
$$ language plpgsql;

drop function if exists games_players cascade;

create or replace function games_players()
returns trigger as $$ begin
update games set players_conf = (select sum(players.num) AS num from players where players.game_id = NEW.game_id group by players.game_id) where games.id = NEW.game_id;
return NEW;
end;
$$ language plpgsql;

drop function if exists games_players cascade;

create or replace function games_players()
returns trigger as $$ begin
update games set players_conf = (select sum(players.num) AS num from players where players.game_id = NEW.game_id group by players.game_id) where games.id = NEW.game_id;
return NEW;
end;
$$ language plpgsql;

drop function if exists games_players cascade;

create or replace function games_players()
returns trigger as $$ begin
update games set players_conf = (select sum(players.num) AS num from players where players.game_id = NEW.game_id group by players.game_id) where games.id = NEW.game_id;
return NEW;
end;
$$ language plpgsql;

Any ideas?

Help with a trigger

Similar Threads

Similar Threads

Similar Threads