On Sat, Mar 12, 2005 at 23:05:41 +0200, Andrus Moor <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
