On 2010-12-30, Lukasz Brodziak <lukasz.brodz...@gmail.com> wrote: > Hello, > > I have a problem with writing a select statement that would return > records for which difference in values of this and following ID is > bigger than 1. Example table > ID Data > 1 Text > 2 Text2 > 5 Text5 > 23 Text23 > 24 TXT > 25 RRRR > > So I need to return rows with IDs 2,5,23.
SELECT id FROM Example EXCEPT SELECT id-1 FROM Example; select * FROM Example WHERE id+1 NOT IN ( SELECT id FROM Example ); > -- > Łukasz Brodziak > "What if everyting around You isn't quite as it seems, > What if all the world You think You know is an inelaborate dream > When You look at Your reflection is that all you want it to be > What if You could look right through the cracks > Would You find Yourself...... Find Yourself afraid to see" > -- ⚂⚃ 100% natural -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
