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 | +--------+----+---------+ | fish | 1 | lax | | mammal | 1 | dog | | mammal | 2 | cat | | mammal | 3 | whale | | bird | 1 | penguin | | bird | 2 | ostrich | +--------+----+---------+ Many thanks, Filip ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
