PL/PGSQL question on transactions
| От | Dan Schwitalla |
|---|---|
| Тема | PL/PGSQL question on transactions |
| Дата | |
| Msg-id | F97NwGSKnt0bu5wvQaT0000c8fb@hotmail.com обсуждение |
| Ответы |
Re: PL/PGSQL question on transactions
|
| Список | pgsql-sql |
Can you imbed BEGIN; and COMMIT; statements in the body of a pl/pgsql function? I am getting a parse error upon execution when I try it. Code: CREATE FUNCTION chitadj(integer,integer) RETURNS integer AS ' DECLARE result integer; oldamount integer; BEGIN BEGIN; SELECT INTO oldamount chits FROM avatar WHERE avatar_id = $1; IF oldamount IS NULL THEN RETURN -1; END IF; IF ((oldamount < abs($2)) AND ($2 < 0)) THEN RETURN -2; END IF; result := oldamount + $2; RETURN result; COMMIT; END; ' language 'plpgsql'; ------------------------- Dan _________________________________________________________________ Join the world�s largest e-mail service with MSN Hotmail. http://www.hotmail.com
В списке pgsql-sql по дате отправления: