Re: question about auto increment like

[------  En réponse à  Josh Berkus :  ------]
 
>>Don,

>>See SERIAL data type.
>>
>>> but  I also want it to automatically adjust all 
>>> other entries in case one of them is deleted if u see
>>what I mean.
>>
>>No, I don't.  Can you be more specific?

say u have 3 entries, the first entry (let's call it A) value is "1" the second(let's call it B) is "2" and the third(let's call it C) is "3".
If I delete B, I would like C value to become "2" ie to take B value.
hope u see what I'm sayin.

thanx in advance