auto-incrementing once more - Mailing list pgsql-general

From Marcin Grondecki
Subject auto-incrementing once more
Date
Msg-id 3.0.5.32.19980805172247.007b6960@mtl.pl
Whole thread Raw
List pgsql-general
Hi,
I'd like to use auto-incrementing possibilities of pgsql
in more sofisticated way then auto-increment one independent
column.
i.e. i've following structure:
client_id     int4
id        int4
etc....
and then, inserting records with the same client_id i'd
like pgsql to autoincrement id - independently for
each client_id (two-dimensional index).
Is there any way to do it?
Maybe more - when inserting record with empty client_id
(and id), pgsql should create next client_id.
Etc... :)
TIA


Marcin Grondecki
mailto:ojciec@mtl.pl

*** Programy powinno sie sprzedawac lacznie z ich tworcami


pgsql-general by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [GENERAL] web-site and redirecting to mirror
Next
From: Thornton Prime
Date:
Subject: The SoundEx Contrib Example