Revision: 70453
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at February 19, 2016 10:10 by kossmoss
Initial Code
SELECT generate_series( (SELECT MIN(id) FROM locations), (SELECT MAX(id) FROM locations) ) AS genid EXCEPT SELECT id FROM locations ORDER BY genid ASC;
Initial URL
Initial Description
http://postgresql.nabble.com/Simple-way-to-get-missing-number-tp5662154p5662212.html
Initial Title
PostgreSQL Find missing ids in a sequence
Initial Tags
Initial Language
SQL