Re: [GENERAL] gap in sequence numbers

2009-09-18 Thread Merlin Moncure
On Fri, Sep 18, 2009 at 10:00 AM, Picavet Vincent wrote: > Hi, > Please consider the following query. > The reftable inner query generates a table with 11 elements, 7 of them > having the groupkey 1, and the 4 others the groupkey 2. This set is then > grouped by the groupkey field, and after that

[GENERAL] gap in sequence numbers

2009-09-18 Thread Picavet Vincent
Hi, Please consider the following query. The reftable inner query generates a table with 11 elements, 7 of them having the groupkey 1, and the 4 others the groupkey 2. This set is then grouped by the groupkey field, and after that a generate_series and a sequence are used to create an ordered id.