Create Sequence on Dual Primary Key

If I have a table like:
create table my_table
(
spec_id,
spec_num,
....<snip - other fields>
)
and then create a primary key like:

alter table task add primary key (spec_id, spec_num)

How do i build a seqence?

spec_id is a foreign key to another table spec_num should be a sequence number within spec_id

examples of spec_id, spec_num combinations:

131, 1
131, 2
131, 3
132, 1

Mike Received on Fri Jun 13 2003 - 22:01:40 CEST