Possible to get LIMIT in an index access method?

Поиск
Список
Период
Сортировка
От Chris Cleveland
Тема Possible to get LIMIT in an index access method?
Дата
Msg-id CABSN6VcacvmoVog6x3ueEk1X4iw_4SzHPiKe82JvsrEdwpH2Mg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Possible to get LIMIT in an index access method?  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
Список pgsql-hackers
I'm developing an index access method.

SELECT *
FROM foo
WHERE col <=> constant
ORDER BY col <==> constant
LIMIT 10;

I'm successfully getting the WHERE and the ORDER BY clauses in my beginscan() method. Is there any way to get the LIMIT (or OFFSET, for that matter)?

My access method is designed such that you have to fetch the entire result set in one go. It's not streaming, like most access methods. As such, it would be very helpful to know up front how many items I need to fetch from the index.

--
Chris Cleveland
312-339-2677 mobile

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Tarball builds in the new world order
Следующее
От: Ranier Vilela
Дата:
Сообщение: re: Direct SSL connection and ALPN loose ends