Re: Multi row sequence?

On Sat, 18 Dec 2004 11:07:37 -0600 Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> On Fri, Dec 17, 2004 at 11:10:12 -0000,
> Filip Wuytack <fwuytack(at)fgscapital(dot)com> 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.

--
Ciprian Popovici