Re: SERIAL type - auto-increment grouped by other field

One possible implementation of a two level numbering outline
will be published in PostgreSQL GeneralBits Issue #64 due
out Monday morning, 3/1.  http://www.varlena.com/GeneralBits/

elein
============================================================
elein@varlena.com        Varlena, LLC        www.varlena.com
                         1-866-VARLENA
          PostgreSQL Consulting, Support & Training

PostgreSQL General Bits   http://www.varlena.com/GeneralBits/
=============================================================
Its a doggy dog world out there.


On Sun, Feb 29, 2004 at 02:44:01AM +0100, Paulovi? Michal wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)