Advanced Search

Return to Snippet

Revision: 70453
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