Re: tricky query

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: tricky query
Дата
Msg-id 20050628193123.GA12571@wolff.to
обсуждение исходный текст
Ответ на Re: tricky query  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Список pgsql-performance
On Tue, Jun 28, 2005 at 12:02:09 -0400,
  Merlin Moncure <merlin.moncure@rcsonline.com> wrote:
>
> Confirmed.  Hats off to you, the above some really wicked querying.
> IIRC I posted the same question several months ago with no response and
> had given up on it.  I think your solution (smallest X1 not in X) is a
> good candidate for general bits, so I'm passing this to varlena for
> review :)
>
> SELECT t1.id+1 as id_new FROM id_test t1
>     WHERE NOT EXISTS
>         (SELECT t2.id FROM id_test t2 WHERE t2.id = t1.id+1)
>     ORDER BY t1.id LIMIT 1;

You need to rework this to check to see if row '1' is missing. The
above returns the start of the first gap after the first row that
isn't missing.

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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: tricky query
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: tricky query