From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pknoob(at)noos(dot)fr |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: question about auto increment like |
Date: | 2003-04-04 00:01:12 |
Message-ID: | 200304031601.12430.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-04-04 00:51:18 | Re: question about auto increment like |
Previous Message | Manfred Koizar | 2003-04-03 23:45:24 | Re: Upgraded from 7.2 to 7.3 |