On Wed, Aug 2, 2017 at 5:56 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> > > On 2 Aug 2017, at 4:54pm, Peter Da Silva <peter.dasi...@flightaware.com> > wrote: > > > Can’t you do the same basic logic then use (SELECT value FROM > super_sequences WHERE id=’SEQ_1’) instead of SEQ_1.nextval? > > Actually, I don’t understand how sequences are superior to normal use of > an AUTOINC column. Can someone explain ? > > Yes I can. I need to use special number that I specified the start and increment. for instance I have a entity with a lower number and upper number, I create then a sequence like CREATE SEQUENCE IF NOT EXISTS SEQ_RANGE START WITH 100 INCREMENT BY 100 ; then I create many entities like: insert into MYENTITY(LowerNumber,UpperNumber) select SEQ_RANGE.currval+1, SEQ_RANGE.nextval from MY_REF_TABLE ; _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
