On Sat, Mar 12, 2005 at 23:05:41 +0200,
Andrus Moor <eetasoft(at)online(dot)ee> wrote:
> I have table containing different types of documents (type A, B and C).
>
> Each document type must have separate sequential ID starting at 1
>
> ID of first inserted record of type A must be set to 1
> ID of first inserted record of type B must be also set to 1
> ID of second record of type A must be set to 2
> etc.
Sequences aren't designed for doing this. If you aren't doing lots of
updates, just lock the table and assign the next id as the current max id
of that type + 1.