SERIAL type - auto-increment grouped by other field

From: Paulovič Michal <michal(at)paulovic(dot)sk>
To: pgsql-general(at)postgresql(dot)org
Subject: SERIAL type - auto-increment grouped by other field
Date: 2004-02-29 01:44:01
Message-ID: 1078019041.404143e15ac52@www.prima.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi all,

I have problem with SERIAL field type (or sequence functionality).
I have table with three columns - ID, IDS, NAME.
I want auto-increment IDS grouped by ID.
Example:
1, 1, Ferdo
1, 2, John
2, 1, Martin
1, 3, Elvira
2, 2, Georgia

but...
when I use IDS - SERIAL and when I create UNIQUE (ID, IDS) result is:
1, 1, Ferdo
1, 2, John
2, 3, Martin
1, 4, Elvira
2, 5, Georgia

where i make misstake??? how can i do it??? in documentation there is
description only for one auto-increment column. I didn't find auto increment as
I described upper. Do you have any idea how can I do it???

tnx a lot

________ Information from NOD32 ________
This message was checked by NOD32 Antivirus System for Linux Mail Server.
http://www.nod32.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2004-02-29 02:42:19 ispell tsearch2 dictionary
Previous Message Christoph Graf 2004-02-29 00:03:27 inheritance of triggers (OO tables)