Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION "public"."update_balance_bet"()
- RETURNS "pg_catalog"."trigger" AS $BODY$
- DECLARE
- currentBalance INTEGER;
- BEGIN
- currentBalance = (SELECT balance FROM "public"."Users" WHERE id=NEW."UserId");
- UPDATE "public"."Users" SET balance=(NEW.amount+currentBalance);
- RETURN NEW;
- END
- $BODY$
- CREATE TRIGGER bet_trigger
- AFTER INSERT ON "public"."Bets"
- FOR EACH ROW
- EXECUTE FUNCTION update_balance_bet();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement