Take the 2-minute tour ×

I am updating a more than one row of a single table. I want one of the table field to be auto incremented while updating. Any help?

I am using Postgresql. Thanks in advance.

share|improve this question
add comment

1 Answer

up vote 3 down vote accepted

You can set a trigger and handle UPDATE operations and increase any field you want there. http://www.postgresql.org/docs/9.1/static/plpgsql-trigger.html

share|improve this answer
add comment

Your Answer


