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