Merlin Moncure wrote:
>I've already worked out a query using generate_series (not scalable) and
>pl/pgsql. An SQL only solution would be preferred, am I missing
>something obvious?
I would be tempted to join the table to itself like:
SELECT id+1
FROM foo
WHERE id > 0
AND i NOT IN (SELECT id-1 FROM foo)
LIMIT 1;
Seems to work for me. Not sure if that's good enough for you, but
it may help.
Sam