How about: *WITH RECURSIVE T(n) AS (* * SELECT 1* * UNION ALL* * SELECT n + 1* * FROM T* * WHERE n < 100* *)* *SELECT SEQ_ID.NEXTVAL AS V FROM T -- Get next 100 entries from sequence SEQ_ID *
Or, just select the range: *SELECT MIN(V) START, MAX(V) END FROM (* *WITH RECURSIVE T(n) AS (* * SELECT 1* * UNION ALL* * SELECT n + 1* * FROM T* * WHERE n < 100* *)* *SELECT SEQ_ID.NEXTVAL AS V FROM T)* //Nicholas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
