Re: select count(*) and limit

Поиск
Список
Период
Сортировка
От Verena Ruff
Тема Re: select count(*) and limit
Дата
Msg-id 446C8C23.6040606@triosolutions.at
обсуждение исходный текст
Ответ на Re: select count(*) and limit  (John DeSoi <desoi@pgedit.com>)
Список pgsql-novice
John DeSoi schrieb:
> A cursor still might be useful, but it would only be used for the
> current request. You could run the query once and fetch the rows you
> want to display from the cursor. Then scan to the end of the cursor to
> find out how many rows it has. The MOVE command does this and returns
> the number of rows.
thanks for this hint. I'll test it.

Regards,
Verena

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