Re: serial column

Choice a.

I am using the numbers to identify devices.

If a device is deleted or replaced with another type of device I want the
numbering to still be sequential.

Bob

----- Original Message -----
From: "Ragnar" <gnari@hive.is>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Sunday, September 24, 2006 2:24 PM
Subject: Re: [GENERAL] serial column


> On sun, 2006-09-24 at 13:50 -0700, Bob Pawley wrote:
>> I need to develop a serial column that always starts at 1 and is
>> sequential even after deletes.
>
> what exactly do you mean?
>
> say you have rows where your
> columns has values 1,2,3 and 4.
>
> you now delete the row where
> the value is 2.
>
> what do you want to happen?
>
> a) the rows with values 3 and 4
> are changed tocontain 2 and 3 ?
>
> b) the next 2 values to be inserted
> to be 2 and then 5 ?
>
> c) something else ?
>
>
> gnari
>
>
>
>