Finding missing values in sequence column

Поиск
Список
Период
Сортировка
От Lukasz Brodziak
Тема Finding missing values in sequence column
Дата
Msg-id AANLkTinVg69x_2_E8G2=Q8V5+cduTVzYKSDUzQoTigCh@mail.gmail.com
обсуждение исходный текст
Ответы Re: Finding missing values in sequence column
Список pgsql-admin
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"

В списке pgsql-admin по дате отправления:

Предыдущее
От: Imre Oolberg
Дата:
Сообщение: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Следующее
От: Szymon Guz
Дата:
Сообщение: Re: Finding missing values in sequence column