Re: serial column
От | Bob Pawley |
---|---|
Тема | Re: serial column |
Дата | |
Msg-id | 006901c6e020$74a762e0$8e904618@owner обсуждение исходный текст |
Ответ на | serial column (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: serial column
Re: serial column Re: serial column |
Список | pgsql-general |
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 > > > >
В списке pgsql-general по дате отправления: