Horton

help with UPDATE sql

Kevin Heflin <kheflin@shreve.net>

View thread View on postgr.es
From: Kevin Heflin <kheflin@shreve.net>
To: "PGSQL-General (E-mail)" <pgsql-general@postgreSQL.org>
Date: 1999-03-15T05:07:06Z
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@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------