Thread: How to... in update

Hi all,

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

Thanks.
--
Marc Soler

> 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