| From: | Kevin Heflin <kheflin(at)shreve(dot)net> |
|---|---|
| To: | "PGSQL-General (E-mail)" <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | help with UPDATE sql |
| Date: | 1999-03-15 05:07:06 |
| Message-ID: | Pine.LNX.4.04.9903142251590.11689-100000@mercury.shreve.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Could some one offer a suggestion on the following.
I have a table of customer information. One of the fields of type int has
the value of a number 1-30.
Currently they are all set to either 10 or 20
I would like to be able to run an update statment, which will fill this
field with 1, then on the next row, 2, then 3, etc then 30, then start
back over at 1
Any suggestions would be appreciated.
Kevin
--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
kheflin(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bernhard Krick | 1999-03-15 09:20:47 | how to start postmaster at system boot on linux? |
| Previous Message | James Puckett | 1999-03-15 02:10:38 | postgres and PERL |