[sqlite] Reusing integer key values

I have a table keyed by an integer column. Each time I insert a row into the table I would like to use the lowest value that does not currently exist in the table as a key. Is there a query that will provide me with the lowest numeric value (for a column) that does not exist in the table? --

Re: [sqlite] Reusing integer key values

Excellent! You were on the mark; I am trying to fill the holes as records are deleted. Thanks Igor! On Thu, 2009-10-08 at 19:45 -0400, Igor Tandetnik wrote: Bob Lauria bob.lau...@sbcglobal.net wrote: I have a table keyed by an integer column. Each time I insert a row into the table I