Don,
> I'm looking for a way to auto increment a field each time an new entry is
> added (kind of like in mysql)
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?
--
-Josh Berkus
Aglio Database Solutions
San Francisco