> It's possible in postgres to increment a row in a UPDATE command.
>
> something like this: UPDATE table set col_name = 'foo', col_name2 ++ WHERE
> condition
UPDATE table set col_name = 'foo', col_name2 = col_name2 + 1 WHERE
condition
Is the above your requirement? If yes, this is how it can be done.
regards,
bhuvaneswaran