Re: FETCH FIRST clause PERCENT option

Поиск
Список
Период
Сортировка
От Surafel Temesgen
Тема Re: FETCH FIRST clause PERCENT option
Дата
Msg-id CALAY4q_t3nUGkCrhWs3=a3ZgbcR-KCzam+6Vtgm1bYuCPT+4wQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: FETCH FIRST clause PERCENT option  (Erik Rijkers <er@xs4all.nl>)
Список pgsql-hackers


On Mon, Aug 19, 2019 at 1:55 PM Erik Rijkers <er@xs4all.nl> wrote:
Another little thing, not sure it's a bug:

limit interprets its argument by rounding up or down as one would
expect:

table onek limit 10.4;  --> gives 10 rows
table onek limit 10.6;  --> gives 11 rows

but  FETCH count PERCENT  does not do that; it rounds always up.

select * from (table onek limit 100) f fetch first 10.4 percent rows
only; --> gives 11 rows
select * from (table onek limit 100) f fetch first 10.6 percent rows
only; --> gives 11 rows

I see that it's documented in the .sgml to behave as it does, but it
seems wrong to me;
shouldn't that 10.4-percent-query yield 10 rows instead of 11?

 

According to sql standard we have to use the result ceiling value

regards
Surafel

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

Предыдущее
От: movead li
Дата:
Сообщение: Re: Rearranging ALTER TABLE to avoid multi-operations bugs
Следующее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: Global temporary tables