Re: Multi row sequence? - Mailing list pgsql-general

From Ragnar Hafstað
Subject Re: Multi row sequence?
Date
Msg-id 1103491642.1867.12.camel@localhost.localdomain
Whole thread Raw
In response to Re: Multi row sequence?  (Ciprian Popovici <ciprian@zuavra.net>)
List pgsql-general
On Sun, 2004-12-19 at 22:43 +0200, Ciprian Popovici wrote:
> On Sun, 19 Dec 2004 13:51:39 +0000 Ragnar Hafstað <gnari@simnet.is> 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 <bruno@wolff.to>
> wrote:
> > > > On Fri, Dec 17, 2004 at 11:10:12 -0000,
> > > >   Filip Wuytack <fwuytack@fgscapital.com> wrote:

[question about mysql's special AUTO_INCREMENT on a secondary column in
a multiple-column index]

> > >
> > > 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.

I am afraid I do not follow you.

gnari



pgsql-general by date:

Previous
From: Ciprian Popovici
Date:
Subject: Re: Multi row sequence?
Next
From: "Vincent Hikida"
Date:
Subject: Re: UNION with more restrictive DISTINCT