renumbering lines in a table

If I have a table TABLE_STUFF like this simple example using two columns to illustrate:

ITEMNO     THINGS
1          APPLES
2          GRAPES
3          PICKLES
4          PEARS

And I do this delete:

DELETE from TABLE_STUFF things = ‘GRAPES’;

At this point if I do a SELECT * from TABLE_STUFF I see this with a gab between 1 and 3:

ITEMNO     THINGS
1          APPLES
3          PICKLES
4          PEARS

Question: How can I easily update the content of itemno, so my table can again look like this (below) where the itemno reflects the actual line position in the table when I do a SELECT * from TABLE_STUFF:

ITEMNO     THINGS
1          APPLES
2          PICKLES
3          PEARS

Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 01 2000 - 14:45:44 CDT