On Sun, 19 Dec 2004 13:51:39 +0000 Ragnar Hafstaà <[EMAIL PROTECTED]> wrote: > On Sun, 2004-12-19 at 15:02 +0200, Ciprian Popovici wrote: > > On Sat, 18 Dec 2004 11:07:37 -0600 Bruno Wolff III <[EMAIL PROTECTED]> wrote: > > > On Fri, Dec 17, 2004 at 11:10:12 -0000, > > > Filip Wuytack <[EMAIL PROTECTED]> wrote: > > > > Is it possible to have a sequence (as a multirow prim key), where > > > > sequence (id) only increase per group of data (grp). > > > > > > Why do you want to do this? It would be a lot simpler to generate unique > > > values over the table and that will work just fine if all you need > > > is uniqueness. > > > > Here's a case where what he said would come in handy: arranging a > > particular display order within the individual groups. You have the unique > > key for the entire table, but you need something like a serial restricted > > to just a group of rows. > > would a normal sequence not do if that was the only purpose?
Not if you need the main key values to stay put. -- Ciprian Popovici ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster