statement level triggers in PostgreSQL , anybody??

Hi,
     I am a bit troubled with the row-level triggers which PostgreSQL
uses when using update table cpmmand.
     For instance, if the primary key column has values 1,2,3,... and
i want to update the whole column as column = colunm + 1 , then there
is an error. This obviously works on databases such as mssql which has
row level triggers.
     Any suggestions so that i do not have to modify the query and
still make it work in the postgresql database ??