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. -- Å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" -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin