Re: question about auto increment like - Mailing list pgsql-novice

From pat pat
Subject Re: question about auto increment like
Date
Msg-id 20030403233829.2E4DA474E42@postgresql.org
Whole thread Raw
In response to question about auto increment like  (Don Patou <pknoob@noos.fr>)
List pgsql-novice
[------  En réponse à  Josh Berkus <josh@agliodbs.com>:  ------]

>>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'scall 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


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Upgraded from 7.2 to 7.3
Next
From: Manfred Koizar
Date:
Subject: Re: Upgraded from 7.2 to 7.3