Re: Serial Type - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Serial Type
Date
Msg-id Pine.LNX.4.30.0105021925280.759-100000@peter.localdomain
Whole thread Raw
In response to Serial Type  ("Christian Marschalek" <cm@chello.at>)
List pgsql-general
Christian Marschalek writes:

> The serial data type automaticaly takes the next higher value, but what
> if there's a drop and I want to assing 3 even if there are 20 records
> and the next higher number would be 21 not 3?

Then you can't use the serial type.  Coding hole-filling serial numbers
can be quite tricky and slow.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Karel Zak
Date:
Subject: Re: chr() command in PG7.03?
Next
From: Doug McNaught
Date:
Subject: Re: Re: Stranger than fiction - EXPLAIN results