question re incrementing an integer field in a table.

From: richard terry <rterry(at)internode(dot)on(dot)net>
To: "'PostgreSQL Novice'" <pgsql-novice(at)postgresql(dot)org>
Subject: question re incrementing an integer field in a table.
Date: 2011-12-16 10:57:40
Message-ID: 201112162157.40818.rterry@internode.on.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hope this question isn't too idiotic and makes sense.

Is there a simple way to increment the value of an integer field in a table in
sql without reading the fields value adding 1 and re-saving? (the field is not
a primary key or any other sort of foreign key)

regards

richard

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thom Brown 2011-12-16 11:09:05 Re: question re incrementing an integer field in a table.
Previous Message Jean-Yves F. Barbier 2011-12-15 13:47:20 Re: Rounding result of expression in SELECT ..AS..