You might want to take a look at- http://www.varlena.com/GeneralBits/ The procedure as shown does not account for renumbering after a delete, but it might serve as a starting point. On Sunday 24 September 2006 07:03 pm, Bob Pawley wrote: > The numbering system is more complex than just assigning a number. It > invloves about thirty procedures which I have put together and find that it > works well. > > I would like to keep the numbering as a database system which will be > possible if I can figure out a way of generating sequential numbers without > possibility of a gap. > > Perhaps a manually built table is the answer?? > > Bob > > > ----- Original Message ----- > From: "Tom Lane" <tgl@xxxxxxxxxxxxx> > To: "Bob Pawley" <rjpawley@xxxxxxx> > Cc: "Ragnar" <gnari@xxxxxxx>; "Postgresql" <pgsql-general@xxxxxxxxxxxxxx> > Sent: Sunday, September 24, 2006 4:30 PM > Subject: Re: [GENERAL] serial column > > > Bob Pawley <rjpawley@xxxxxxx> writes: > >> 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. > > > > It sounds to me like you oughtn't be storing these numbers in the > > database at all. You just want to attach them at display time --- they > > are certainly utterly meaningless as keys if they can change at any > > moment. > > > > regards, tom lane > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: don't forget to increase your free space map settings > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly -- Adrian Klaver aklaver@xxxxxxxxxxx
