PSQL row update using NEW statment
since it is possible to do: INSERT INTO some_table VALUES (NEW.*) in pl/pgsql can we do somethin开发者_StackOverflow社区g similar but for UPDATE clause using NEW ? I mean i want to update some row using values from NEW object.
Thanks in advance.
it is possible to do what you haved mentiened.please refer to the following link:
http://www.postgresql.org/docs/current/interactive/plpgsql-trigger.html
精彩评论