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?

gnari


 


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to