FETCH FIRST clause PERCENT option

Поиск
Список
Период
Сортировка
От Surafel Temesgen
Тема FETCH FIRST clause PERCENT option
Дата
Msg-id CALAY4q9Esidbuz4fvUrGA-uOHNwbEsntLZQ8p=_okDvaTzJ3pA@mail.gmail.com
обсуждение исходный текст
Ответы Re: FETCH FIRST clause PERCENT option
Список pgsql-hackers

FETCH FIRST with PERCENT option is SQL standard that state limit count to be specified in a percentage in addition to specify it in exact count and listed as one of Major features simply not implemented yet in recent wiki page [1].

I implemented it by executing the query plan twice. One without limit filter to find the total number of row that will be feed to limit node so the exact limit count can be calculated and the query plan execute again with limit filter with newly calculated exact count .


[1].https://wiki.postgresql.org/wiki/PostgreSQL_vs_SQL_Standard


Regards

Surafel

Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: C99 compliance for src/port/snprintf.c
Следующее
От: Andres Freund
Дата:
Сообщение: Re: FETCH FIRST clause PERCENT option