Re: sequence

If I have a table like:
create table my_table
(
spec_id,
spec_num,
...
)
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

same problem

--
Posted via http://dbforums.com