[GENERAL] Multi row sequence?

2004-12-17 Thread Filip Wuytack
Hi, I just started looking into PostgreSQL (coming from Mysql before), but have a question: Is it possible to have a sequence (as a multirow prim key), where sequence (id) only increase per group of data (grp). E.g. +++-+ | grp| id | name| +++-+ |

Re: [GENERAL] Multi row sequence?

2004-12-18 Thread Michael Fuhr
On Fri, Dec 17, 2004 at 11:10:12AM -, Filip Wuytack wrote: > Is it possible to have a sequence (as a multirow prim key), where sequence > (id) only increase per group of data (grp). > > E.g. > +++-+ > | grp| id | name| > +++-+ > | fish | 1 |

Re: [GENERAL] Multi row sequence?

2004-12-18 Thread Bruno Wolff III
On Fri, Dec 17, 2004 at 11:10:12 -, Filip Wuytack <[EMAIL PROTECTED]> wrote: > Hi, > > I just started looking into PostgreSQL (coming from Mysql before), but have > a question: > > Is it possible to have a sequence (as a multirow prim key), where sequence > (id) only increase per group of d

Re: [GENERAL] Multi row sequence?

2004-12-18 Thread Bruno Wolff III
On Sat, Dec 18, 2004 at 17:19:27 -, Filip Wuytack <[EMAIL PROTECTED]> wrote: > I'm working on a database that will contain companies (group) and the > relevant listing (securities-> id) and related periodic information. I want > the end users of the data to see the relationship between the 2

Re: [GENERAL] Multi row sequence?

2004-12-19 Thread Ciprian Popovici
On Sat, 18 Dec 2004 11:07:37 -0600 Bruno Wolff III <[EMAIL PROTECTED]> wrote: > On Fri, Dec 17, 2004 at 11:10:12 -, > 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). > > Wh

Re: [GENERAL] Multi row sequence?

2004-12-19 Thread Ragnar Hafstað
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 -, > > Filip Wuytack <[EMAIL PROTECTED]> wrote: > > > Is it possible to have a sequence (as a multirow prim key), whe

Re: [GENERAL] Multi row sequence?

2004-12-19 Thread Bruno Wolff III
On Sun, Dec 19, 2004 at 15:02:27 +0200, Ciprian Popovici <[EMAIL PROTECTED]> 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 -, > > Filip Wuytack <[EMAIL PROTECTED]> wrote: > > > Is it possible to have a sequence (a

Re: [GENERAL] Multi row sequence?

2004-12-19 Thread Ciprian Popovici
On Sun, 19 Dec 2004 13:51:39 + 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 -, > > > Filip Wuytack <[EMAIL PRO

Re: [GENERAL] Multi row sequence?

2004-12-19 Thread Ragnar Hafstað
On Sun, 2004-12-19 at 22:43 +0200, Ciprian Popovici wrote: > On Sun, 19 Dec 2004 13:51:39 + 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 F

Re: [GENERAL] Multi row sequence?

2004-12-20 Thread Filip Wuytack
I'm working on a database that will contain companies (group) and the relevant listing (securities-> id) and related periodic information. I want the end users of the data to see the relationship between the 2 (comp A, security 01, security 02;comp B, security 01, security 02) in the key (company,s