Re: where's the gap in the sequence ?

On Sun, Mar 20, 2005 at 05:17:03 +0100,
Zouari Fourat <fourat(at)gmail(dot)com> wrote:
> Hello
> i have a column 'id' wich is a sequence incremented by 1
> i did a verification on my table and found that i probably got some
> lines deleted from the table.
> i compared the count(*) and the max(id) and found that there is a
> difference of 400 lines.
> how to seek that gap in my table ? i want to know wich id value every
> line from the 400 deleted lines got.
> how to do it ?
> thanks

If you are using 8.0.x, you can use the generate_series function to generate
the set of possible IDs and then use set difference (EXCEPT), a left
join or NOT EXISTS to remove the set of ids that were used.