> On Mar 19, 2020, at 7:35 PM, pabloa98 <pablo...@gmail.com> wrote:
>
>
>
> On Thu, Mar 19, 2020 at 6:16 PM Rob Sargent <robjsarg...@gmail.com
> <mailto:robjsarg...@gmail.com>> wrote:
>
>
>> On Mar 19, 2020, at 6:45 PM, pabloa98 <pablo...@gmail.com
>> <mailto:pablo...@gmail.com>> wrote:
>>
>>
>>
>> On Thu, Mar 19, 2020 at 5:13 PM Adrian Klaver <adrian.kla...@aklaver.com
>> <mailto:adrian.kla...@aklaver.com>> wrote:
>> On 3/19/20 3:32 PM, pabloa98 wrote:
>> >
>> >
>> > On Thu, Mar 19, 2020 at 3:17 PM Rob Sargent <robjsarg...@gmail.com
>> > <mailto:robjsarg...@gmail.com>
>> > <mailto:robjsarg...@gmail.com <mailto:robjsarg...@gmail.com>>> wrote:I
>> > have a table called "pair":
>>
>> CREATE TABLE pair(
>> group INT NOT NULL,
>> element INT NOT NULL,
>> CONSTRAINT PRIMARY KEY (group, element)
>> );
>>
>> I must add entries to the table "event". This table event will have a code
>> that will be generated using a sequence of that is a function of
>> s(group,element).
>> CREATE TABLE event(
>> group INT NOT NULL,
>> element INT NOT NULL,
>> code INT NOT NULL,
>> CONSTRAINT PRIMARY KEY(code, element, group)
>> );
>>
> Unless event table is searched by code more than group, you probably want to
> maintain the key order from the pair table's primary key.
>
> OK. I will do that.
>
> If gaps are ok do you still near multiple sequences?
>
> I need to start each "code" value from 1 in each (group, element) pair. This
> is because we only have 99999999 codes for each pair. We do not want to waste
> numbers. If there is a gap is OK but no a gap of millions of numbers.
