Re: question about auto increment like

Pat,

> 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.

What do these numbers represent?   If we're talking about a key for the table, 
that's such a bad idea I won't help you with it.   If we're talking about 
something else (like an entry sequence number) there are a few ways to do it, 
but an auto-increment number (e.g. SERIAL) isn't one of them.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco