| From: | Thom Brown <thom(at)linux(dot)com> |
|---|---|
| To: | richard terry <rterry(at)internode(dot)on(dot)net> |
| Cc: | PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: question re incrementing an integer field in a table. |
| Date: | 2011-12-16 11:09:05 |
| Message-ID: | CAA-aLv4TdHdwtR=ctijtv+P=mgre0iSwxCL3MuZ2Bthd_EpF7g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 16 December 2011 10:57, richard terry <rterry(at)internode(dot)on(dot)net> wrote:
> 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)
Hi,
You will either want to create a column with the pseudo type "serial"
or create a sequence and set the default value of an existing integer
column to use that sequence. See the documentation:
http://www.postgresql.org/docs/current/static/datatype-numeric.html#DATATYPE-SERIAL
Regards
Thom
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2011-12-16 11:24:56 | Re: question re incrementing an integer field in a table. |
| Previous Message | richard terry | 2011-12-16 10:57:40 | question re incrementing an integer field in a table. |