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@sss.pgh.pa.us>
> To: "Bob Pawley" <rjpawley@shaw.ca>
> Cc: "Ragnar" <gnari@hive.is>; "Postgresql" <pgsql-general@postgresql.org>
> Sent: Sunday, September 24, 2006 4:30 PM
> Subject: Re: [GENERAL] serial column
>
> > Bob Pawley <rjpawley@shaw.ca> 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@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Adrian Klaver
aklaver@comcast.net
